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.
Sp_help provides a lot of information about the structure of the tables inside your database. You can highlight a table name in the SQL Query editor and then press the Alt
MySQL provides many utilities for verifying and taking corrective actions in case of failures. One such tool is mysqlcheck Usage: [root@mypc]# mysqlcheck -h -u -p –analyze –databases ; The above
Protocol Buffers are considered to be one of the fastest serializer and deserializer and respond with a lightweight response. You can implement this on the ASP.Net WebAPIs using the Web
POSITION is a powerful function that helps you to find the position of a sub string in a string. Typically, the string is a column in a given table and
You can obtain the oldest Open Transaction in the following way: — Create temporary table for results. CREATE TABLE #OpenTrans ( CurrTrans VARCHAR(25), CurrTransDet SQL_VARIANT ); — Insert info in
One of the main advantage of CSS is using the to achieve total flexibility in terms of styling. In the the contents are ‘locked’ within a cell. It’s safe to
Queries like the one below will perform more slowly than they could be run on a varchar column. Explicitly marking them as such will improve the performance of EF queries
import java.time.*;import java.time.format.*;class LocaleDate{ public static void main(String args[]) { LocaleDate localeDate = new LocaleDate(); localeDate.proceed(); } private void proceed() { DateTimeFormatter formatter; //Creating an instance to the current time
Use the “@” symbol to prefix a string that has characters. You do not have to escape the characters in the string. For example, instead of: Var filePathString = “C:\mydocs\share\audit.docx”;
You can force a like condition to compare only alphabetic values. Here is how: ORDER BY CASE WHEN LTrim(RTrim(Place.Name)) NOT LIKE ‘%[^0-9]%’ THEN 1 ELSE 2 END, Place.Name
Class beanClass = ???If (beanClass.newInstance() instanceof TestBean) ??? The above code is tries to use the reflection API, it tries to find a way to check for inheritance, but it
Devart introduced a noteworthy update of dotConnect for FreshBooks and SSIS Data Flow Components with the support for New FreshBooks API (alpha) to make data access process even more seamless.
Java has some predefined ways of validating an URL. Here is a code snippet: import java.net.*;public class URLValidator{ String validURL = “http://google.com” ; String inValidURL = “httpgoogle.com” ; public static
Often, we have queries where we are interested to see if there is a record for the particular where?condition or the first record. These kinds of queries are used in
The package java.time has APIs to get all the available zone ids. The API is getAvailableZoneIds(). import java.time.*;import java.util.*;public class AllTimeZones{ public static void main(String args[]) { AllTimeZones allTimeZones =
You can fetch records that are common to one or more tables by using INTERSECT. Here is a small example: Select * from EmployeesIntersectSelect * from RetiredEmployees
Byte[] pdf = toPdf(file); Here, a method creates a PDF file from some input and returns the binary PDF data as a byte array. This code expects that the generated
Devart has released a greatly improved Review Assistant 4.0, a code review tool for creating review requests and responding to them without leaving Visual Studio. The tool received numerous review workflow enhancements including new statuses and comments, a single diff-tool window to view changes, improved code review board and many others.
Often, assemblies are distributed to vendors to consume your code. Changes to such assemblies are always hectic to manage. If we are removing or switching methods or properties in a
You may want to know whether an IP address is a multicast address or not in order to make a decision on how to proceed with it. Java supports this
SQL Server, by design, caches query plans for queries. For reuse of cache, the best practice would be to include the schema name in the query. For example: select *
You can replace new lines and spaces inside a field with a statement similar to the following: REPLACE(REPLACE(LTRIM(RTRIM(FIELD_NAME)), CHAR(13), ”), CHAR(10), ”)
It’s always a good idea to get an instant preview of the layout while optimizing your CSS code. It helps you to understand and debug CSS styles better. There are
Iterating a list and printing the values is very simple, as illustrated by the code snippet below. import java.util.*;public class DoubleColon{ public static void main(String args[]) { DoubleColon doubleColon =
The ExceptionDispatchInfo class can be found in System.Runtime.ExceptionServices namespace and is used to capture an exception that occurs at a point, and it can be thrown later using the ExceotionDispatchInfo.Throw
This class belong to java.time package. There are many options available, but here we will be using the ZoneId to get the current time. import java.time.*;public class UsingOffsetDateTime{ public static
Setting a default NULL Date in SQL is quite easy, you just need to concentrate. A statement similar to the following will convert any NULL value inside the specific DATE
This code uses the class loader that loads the current class and getClass() could return something unexpected, like a subclass, or a dynamic proxy. This is hardly ever what you
HTTP2 is binary protocol released some time after 2015. It is completely multiplexed and allows you to send multiple requests via a single TCP connection. It also reduces additional round
https://play.google.com/store/apps/details?id=com.steevjames ‘The Typing Game’ helps improve ones skill in typing in mobile. It is a fun, addictive and educational game. Compete with you friends and have fun ! * This is a small sized game ( Just 1 MB ).* The game does not have any sorts of advertisements.* It is a very user friendly app.* The Typing Game does not require any permission to install or run making it fully safe.* The game uses a simple approach that is easily understandable so even small children can use it.* The app is rated for age 3+ in google play.* This game does not run in the background.
