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.
In case you are wondering, yes, there is a different way to transpose columns into rows than making use of a PIVOT structure. However, it is quite a lot of
In HTML, all included elements can be made editable. To do this, we can use the contenteditable attribute. Here’s an example where the user can modify the content: Contenteditable Now the
Word allows you to navigate through hyperlinks when you use the ctrl+click combination, You can turn this default behaviour off, and navigate by just hovering on the link and clicking it. To disable, please go to File – Options and then choose Advanced- Editing options. Disable the checkbox next to ???Use Ctrl + Click to follow hyperlink???
If you are using windows and Microsoft applications like Work and Excel, you can easily repeat your last executed action with a keyboard shortcut. All you have to is press the F4 key. For e.g. if you have marked the text in bold, or adding a new line in a table or any other actions, all you have to do to repeat that action is press the F4 key and the respective actions will repeat.
Getting the attention of a user is easily achieved in Java with the following code. Listing 1. public class Beep{ public static void main(String args[]) { Beep beep = new
One of the ways to bind filtered data to an element is by using the filter module in AngularJS. See below for an easy example that filters a collection of
You may want to know the temp location in your environment to use it for some purpose during the execution of the program. Here is the code to help. public
A very common task is to backup a table’s data, but sometimes we’d just like to copy a table’s structure. This quick tip will demonstrate how to copy a table’s
SQL 2016’s RLS Feature allows you to implement restrictions on data row access. You can use this business rule manager to enforce rules that are difficult to achieve through the
The method below does nothing because the returned Date is exactly the same with the input value. Always remember that the Date does not carry time zone information, it is
Easily find the end of file that you are processing. Scanner again has a easier way of doing it. import java.util.*;import java.io.*;public class EndOfFile { public static void main(String args[])
To escape curly braces in c#, use double curly braces. See the example below. var stringWithCurlyBraces = string.Format(“Good {{ ???{0}??? }}”,”example”);Console.Write(stringWithCurlyBraces);//will output Good { ‘example’ }
In order to create a Snapshot of your database, you can use the following code: DECLARE @DBName VARCHAR(100) = ‘DBName’DECLARE @CurrentDate VARCHAR(20)SET @CurrentDate = ‘_’ + CONVERT(VARCHAR(20), GETDATE(), 120)SET @CurrentDate
The HTML5 attribute allows you to display a hint value describing what is expected as the field value in a form. This attribute works on the following types of entries:
Add a new bookmark in your browser with the URL set to the script below. Now, on any Angular page, if you click on the bookmark link, it will execute
public class UsingLangDotMath { final int TWENTY_SEVEN = 27; public static void main(String args[]) { UsingLangDotMath usingLangDotMath = new UsingLangDotMath(); usingLangDotMath.proceed(); } private void proceed() { System.out.println(“Cube root of 27: ” + Math.cbrt(TWENTY_SEVEN)); System.out.println(“Trigonometric sine: ” + Math.sin(TWENTY_SEVEN)); System.out.println(“Trigonometric cosine: ” + Math.cos(TWENTY_SEVEN)); System.out.println(“Trigonometric tangent: ” + Math.tan(TWENTY_SEVEN)); } } /* Expected output: [root@mypc]# java UsingLangDotMath Cube root of 27: 3.0 Trigonometric sine: 0.956375928404503 Trigonometric cosine: -0.2921388087338362 Trigonometric tangent: -3.273703800428119 */
Did you know that execution of a Java program will continue only when there is at least one user thread running? In cases in which there are no user threads,
The following query will enable you to list all the tables in your database that doesn’t have an IDENTITY Column: SELECT SysSchemas.name + N’.’ + SysTables.name FROM sys.tables AS SysTables
What makes companies order custom software development despite it may cost them a fortune? Properly designed and developed, custom software becomes an optimal solution to the customer???s business challenge, providing them with useful features only. What is more, custom software allows flexibility to introduce any changes required. This way it is possible to rebuild the existing solution to make it correspond to updated requirements. As a result, a business opting for custom software gains a competitive advantage over their rivals sticking to off-the-shelf solutions with their rigid and limited functionality. Let???s look at several custom software examples to understand the benefits brought by custom software. To keep pace with the Automation age, businesses strive to apply automation technologies to increase the efficiency of their processes and conduct them without human assistance. Consider the following projects based on the automation technologies.
Calendar c = Calendar.getInstance(); c.set(2017, Calendar.OCTOBER, 29); This code behave as a Gregorian calendar, but if the returned Calendar subclass is a Islamic, Julian, Buddistic or Hebrew calendar, then the month called October or the year 2017, doesn’t exist. Calendar.getInstance() uses the current default locale to select an appropiate implementation. The utility of Calendar.getInstance() is very limited and it should be avoided because it’s results is not properly defined. Calendar c = new GregorianCalendar (timeZone); c.set(2017, Calendar.OCTOBER, 29);
There are cases in which we might want to warn the user before an attempt is made to download a large file, or we might simply be interested to know
Images with absolute positioning can be clipped very easily with the CSS Clip property. The syntax is as below. .clippedImageStyle { position: absolute; clip: rect(100px, 150px, 175px, 30px);}
Use the following query to get the total number of rows for each table in your database: CREATE TABLE #TempTable ( [Table Name] [varchar](max), [Total Records] int ); EXEC sp_MSForEachTable
Map map = new HashMap(collection.size());for (Object obj : collection) { map.put(obj.key, obj.value);} The code above wants to make sure that the HashMap doesn’t need to be resized, so its sets
We can use “|=” and configure the ServicePointManager’s SecurityProtocol to turn on the TLS versions and thereby not remove support for other protocols. System.Net.ServicePointManager.SecurityProtocol |= SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12; ? Visit
We can use “|=” and configure the ServicePointManager’s SecurityProtocol to turn on the TLS versions and thereby not remove support for other protocols. System.Net.ServicePointManager.SecurityProtocol |= SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12;
We can use the Random class available in the java.util package to generate random numbers. The code sample below demonstrates generation of a random number with an upper limit. Listing
The following commands are handy to know the current version and the supported engines in the MySQL. Command: SELECT VERSION()Output: 5.6.31-enterprise-commercial-advanced-logCommand: SHOW ENGINESOutput: InnoDBCSVMyISAMBLACKHOLEMEMORYFEDERATEDARCHIVEMRG_MYISAMPERFORMANCE_SCHEMA
Press Alt and P keys together to get a quick preview of the file in windows explorer. A preview is shown on the right pane. There is no need to change the view or install any third-party plugins for this.
The code below is improper because it shares a static instance of a SimpledateFormat with any possible number of threads. Public class Constants { Public static final SimpleDateFprmat date =
