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.
Over a long period of time, we add lot of stuff knowingly or unknowingly to applications such as Microsoft Word. This results in slowing load times. To optimize this behaviour,
MySQL queries can help us work with null values in queries and behave as we need. IFNULL?is a suitable function and can be used where you want to treat null
Executable JAR files are the easiest way to assemble Java code into a single file which can be executed. Assuming that you have an executable JAR file with pathname ,
Compress: Compresses input data and returns the binary data of type VARBINARY(MAX) Decompress: Decompresses compressed input binary data and returns the binary data of type VARBINARY(MAX) Here is small example
Imagine, you want to schedule activating a task few moments (3 seconds in this case) from now, and interval of 3 seconds. The following code will be helpful. import java.util.*;//We
Type shell:sendto in your run menu and press the enter key. This will open a folder in Windows Explorer. Just drag-and-drop your favourite shortcuts to this folder. And next time, you
Find the IP address of a server that you know, for example: google.com. Java, as usual, provides a very easy mechanism to retrieve the IP address of a server that
Dereferencing happens using the . operator: Object object = new Object();String text = object.toString(); // ‘object’ is dereferenced. Dereferencing pursues the memory address placed in a reference, to the place
With the ASCII function you can return a certain character’s ASCII value, as shown in the following example: SELECT ASCII(‘A’) AS A, ASCII(‘B’) AS B, ASCII(‘a’) AS a, ASCII(‘b’) AS
We often create console applications to write test code or to do quick experiments in Visual Studio because they are lightweight when compared to Windows/Web applications. Visual Studio 2015 provides
In Java, static keyword usage on variables means that memory is allocated and it will not be possible for the garbage collector to reclaim the memory until the application terminates.
There are lot of .NET helper assemblies that help you represent datetime in more readable formats, such as yesterday, 5 minutes ago, and so on. One of the libraries that
The format() method from SimpleDateFormat class helps to convert a Date object into certain format String objects by using the supplied pattern string. Date today = new Date();SimpleDateFormat dateFormat =
The HASHBYTES?function returns the MD2, MD4, MD5, SHA, SHA1, or SHA2 hash of a string. The next example returns a SHA1 hash value of it the string that was input.
During the development lifecycle, we may decide on a name for a table and later want to rename it based on the usage of the table. Let’s assume that there
You can use HttpResponse’s IsClientConnected property to figure out if the connection is still alive. Based on the value, you can kill a long-running process if the client is not
For a given number, it may be necessary to know the sign of the number for computation purposes. If it is positive, zero or negative, you may have respective case
Java provides the instanceof operator to test if an object is of a certain type, or a subclass of that type. The program can then choose to cast or not
SQL Server 2017 provides the CONCAT_WS function that allows you to concat a series of strings with a separator.
Go to Data Menu, choose the “From Web” option under the “Get External Data” section. Put a valid web page address, and click on “Import” button at the bottom. It
MySQL is capable of returning the result of a LIKE directly in the result set itself. For example, if you use a wildcard character in a query such as below,
Macros are to be scripted in VBA. However, you really don’t have to know VBA scripting to write a macro for your repeated tasks. Microsoft Office provides you a way
The ordinal() method on the enum returns the constant. In other words, you can assume this to be the same as index and similar to arrays the index starts with
In Java, objects can be cast explicitly and implicitly: implicit casting happens when the source type extends or implements the target type (casting to a superclass or interface). explicit casting
If you want the scripts to load at the end of the page load process, just add the “defer” keyword to the script tag. Such scripts will be executed when
At times, you need to create temporary files to perform certain actions. The following code segment illustrates the same: import java.io.*;public class CreateTempFile{ public static void main(String args[]) { CreateTempFile
We sometimes forget to turn debug to false or turn off tracing. You only need to set the following configuration in the machine.config file in the web server. It will
There are plenty of commands in MySQL that are supported for particular types of storage engines. We can use the following command to know the ENGINE type. SHOW TABLE STATUS
Use LocalDate and ChronoUnit: LocalDate date1 = LocalDate.of(2018, 8, 10); LocalDate date2 = LocalDate.of(2018, 8, 30); As long as the method between of the ChronoUnit enumerator takes 2 Temporals as
At times, your device can be exposed using multiple interface cards. The following code sample will help identify various interfaces and the related IP configuration available on them. import java.net.*;import
