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.
We write a lot of event logs from .NET applications and others. There are use cases in which you need to read them by logging into the actual machine. It
You can write “not equal to” in two different ways in SQL: !=
The preload resource hint can give the browser a head start on loading your site’s CSS and it also signals the browser to initiate an early fetch for an asset.
Have you felt a need for enums to have composite values? They can be defined internally within the enum as below: Public enum livingObjects {Humans,Animals,Plants,All = Humans | Animals |
Use cases where we need to have the result with varying decimal places are possible. You can change the value in the resulting field using the TRUNCATE function. Consider the
Write a test method around the block of code that you want to test as an independent piece. Then, compile the code. Just open the test explorer window and right
LocalDate tomorrow = LocalDate.now().plusDays(3);LocalDateTime anHourFromNow = LocalDateTime.now().plusHours(10); Long daysBetween = java.time.temporal.ChronoUnit.DAYS.between(LocalDate.now(), LocalDate.now().plusDays(2));Duration duration = Duration.between(Instant.now(), ZonedDateTime.parse(“2018-08-30T09:00:00+01:00[Europe/Stockholm]”));
The * enables you to select all elements of a particular selector. For example, if you used *pand then added CSS styles to that, it would do it to all
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
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 *
