Menu
Since 1998, DevX has helped people start businesses, build websites, and provide enterprise technology to people globally. Interviewing the likes of Microsoft’s co-founder, Steve Ballmer, the publication brings comprehensive, reliable, and accessible insights to the Internet.
Outlook has introduced a feature to clean-up conversations in a folder including or excluding its sub folders. This removes the repeated replies on an email thread, and keeps the latest
The following query can be used to get details such as when the Stored Procedure was last updated???as well as its content. SELECT CREATED, LAST_ALTERED, SPECIFIC_NAME, ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITIONFROM lms_db.INFORMATION_SCHEMA.ROUTINES
Use one of the following methods to check if a list is empty in Python: a. If not listname: print(“list is empty”)b. if len(listname) == 0: print(“list is empty’)
Using the System.Net.WebRequestMethods.FTP class, we can use the “SIZE” FTP Protocol method to get the size of the file in FTP. Below is an example in C#: var request =
In jQuery, we use a delay in the $.debounce function to limit repetitive calls in components such as the instant search. We can do that in AngularJS as well, using
Lambda expressions have simplified the way we write code. For example, let’s see how to use a method from an interface. This works with Java 1.8 only. Expected output: Welcome
In order to floodfill drawn objects, you can make use of the following sample: using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;namespace FloodFill{ public partial class Form1 : Form
The default assembly path is usually set to the bin folder of the project. However, there are certain times when it’s best to push the assemblies to a common folder.
Using underscores in numerals is allowed in Java. This is for better readability and representation. The example below illustrates the same value being written in two different forms and results
We can use an alias for long namespaces and use it further down in the code. For an example, see below: //InteropExcel is the aliasusing InteropExcel = Microsoft.Office.Interop.Excel;public class SpreadSheetInteropHelper{
Scanner is a simple and easy-to-use utility provided by Java. import java.util.Scanner;public class ScannerDemo{ public static void main(String args[]) { Scanner scanner = new Scanner(System.in); //Initializing the Scanner with the
Use the following code to block and unblock Internet connectivity on a user’s PC: using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Diagnostics;using System.IO;using System.Reflection;namespace BlockInternet{ public partial class
1. SELECT FROM TableA A INNER JOIN TableB B ON A.key=B.key2. SELECT FROM TableA A RIGHT JOIN TableB B ON A.key=B.key 3. SELECT FROM TableA A RIGHT JOIN TableB B
Class diagrams help you to understand code a lot more quickly through visual representation. Visual Studio, by default, provides you with a one-step process to generate self-updating Class diagrams. Right-click
Optional makes it easier in cases where the result is not really needed. This example can be fine-tuned as needed to explore all of the methods supported. import java.util.Optional;public class
Visual Studio can help you create a GUID quickly. Go to Tools – Create GUID and choose one of the GUID formats. It allows you to copy the newly generated
It can become quite frustrating when you cannot remember the name of an SQL stored procedure, especially if you have quite a few of them. But, let’s say that you
It can become quite frustrating when you cannot remember the name of an SQL stored procedure, especially if you have quite a few of them. But, let’s say that you
To detach from a Docker container and leave it running, you can use the CTRL -p or CTRL -q command.
The java.lang.management.ThreadMXBean is an interface that helps us to understand a lot about Threads in our code. There are numerous methods that participate to provide excellent visibility of the Threads. Something
Devart, a recognized vendor of professional database management software for developers and DBAs, announced the release of dbForge Studio for SQL Server v5.5 with such significant features as Executed SQL Statements History, Support for Surround SCM predefined template, SQL Server 2016 Service Pack 1 (SP1) and SQL Server 2017 CTP2 new syntax support. dbForge Studio for SQL Server v5.5 has received multiple improvements, and here are only several of them: * SQL Server 2017 RC2 new syntax supported;* Query Execution History – dramatically redesigned;* New Feature – Monitor Server Performance;* Lots of improvements in:– Schema Compare – Data Generator– Source Control– Code Completion– Documenter– Index Manager dbForge Studio for SQL Server is an integrated environment for SQL Server development, management, administration, data reporting, and analysis. SQL Manager tool allows users to create, edit, copy, attach and detach, backup and restore databases from one server to another easily. These SQL tools help developers to manage databases, make complex database changes and speed up routine tasks.To learn more, visit http://www.devart.com/dbforge/sql/studio/About DevartDevart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects. Learn more about Devart at https://www.devart.com.
The valueOf() method is useful when you do not know the value contained and it might throw a NullPointerException. It returns null and you can handle the same in your code
Use the GetLeftPart method on the HttpRequest’s URI with Authority as the UriPartial’s value to retrieve the DNS Name. string dnsName = HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority); ? Visit the DevX Tip Bank ?
Use the GetLeftPart method on the HttpRequest’s URI with Authority as the UriPartial’s value to retrieve the DNS Name. string dnsName = HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority);
It is quite easy to find out which tables in your database(s) do not have Primary Keys. You can use the following SQL script: SELECT s.name + N’.’ + t.name
Improve Java performance with MAP. Add Contains keys Next Data StructureHashMap O(1) O(1) O(h/n) Hash TableEnumMap O(1) O(1) O(1) ArrayLinkedHashMap O(1) O(1) O(1) Hash Table+Linked ListTreeMap O(log n) O(log n)
We can see that the method println is referred by System.out using :: import java.util.*;public class NewForEach { public static void main(String args[]) { List empNames = new ArrayList(); empNames.add(“Andrew”);
ASP.NET websites need some static data to be initialized, so that subsequent requests can utilize the loaded data and load much faster. It is a common practice to write such
ASP.NET websites need some static data to be initialized, so that subsequent requests can utilize the loaded data and load much faster. It is a common practice to write such
During testing or monitoring, there is a constant need to monitor the number of sessions created, so as to better correlate the performance metrics collected. The Performance Monitor tool is
