
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.
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

The java.util.Arrays class has an asList method to convert the argument array into a list. This will be handy when there are large amounts of information that you need to
To join the objects in a collection, such as a string array, with a common delimiter like a comma or another character, is quite easy with the string.join method. See
Instead of just traversing a list, this is a newer way of splitting and then iterating the list: import java.util.Arrays;import java.util.List;import java.util.Spliterator;public class UsingSpliterator{ public static void main(String args[]) {
Tableizer is an external app that is great for building HTML tables out of data, using existing Calc or Excel spreadsheet templates. You only need paste your cells into the
We often do String.ToUpper()?on two strings to compare them. This introduces additional overhead on string allocation. It is better to use OrdinalIgnoreCase?instead, as shown below: bool CompareResult = firstString.Equals(secondString, StringComparison.OrdinalIgnoreCase);
A list with a set of values can be reversed using the reverse() method. import java.util.*; public class ReverseACollection{ public static void main(String[] args) { List dataList = new ArrayList();
In order to copy, press the shift key and right-click the file for which you need the path. In the context menu that appears, you will find a new option
The difference is visible when you use the single quote with the + sign. The char value is converted to the ascii value and then summed up. However, you have
To be sure that you are seen on Google, and other search engine, searches, you should make sure that you have provided meta data about your website. Also, to make

The following statement shows the indices on a table in MySQL. SHOW INDEX FROM ‘LogMaster’
If you have multiple strings, you can use StringJoiner to join them efficiently. import java.util.StringJoiner;public class UsingStringJoiner{ public static void main(String args[]) { UsingStringJoiner usingStringJoiner = new UsingStringJoiner(); usingStringJoiner.proceed(); }

One way to speed up the Windows startup process is to remove unwanted programs. You can do this using the Startup options of the System Configuration window. To launch System

Consider the following table that already exists: CREATE TABLE ‘NUMBERS_TABLE’ (‘ONE’ INT(11) NULL DEFAULT NULL,’THREE’ INT(11) NULL DEFAULT NULL,’FIVE’ INT(11) NULL DEFAULT NULL)COLLATE=’utf8_bin’ENGINE=InnoDB; And we want to add a new
The tag can be used to add highlights to text. You can choose the color of the highlight. The code looks like this: This is highlighted text.
Create a file called app_offline.htm with an appropriate maintenance message. Just place this file in the root directory of the web application. IIS and the ASP.NET Framework will stop serving new
See how to use the disjoint method in Collections to find if the given lists are completely disjointed: import java.util.*;public class UsingDisjointInCollections { public static void main(String args[]) { UsingDisjointInCollections
MySQL provides a schema named information_schema. This has a table named TABLES that has detailed information on the available tables, their record count, etc. The query below helps you with











