Home2016August

August 2016

Showing 1 - 13 of 13 results
There are times when you want to kill all the current active connections of your SQL Server database and you...
Assume a scenario where you are trying to get the records from the table where some of the records contains...
If you want to pause the execution of the code block until a specific time is reached , you can...
If you want to pause the execution of the code block for a specific amount of time , you can...
To check if the table exists in a database in SQL Server , you can use the INFORMATION_SCHEMA view. How...
You might want to sort the results of an query in a different order from the traditional sort (Ascending/Descending) order....
There are times when you don’t have a specific value to find but you might have to use the general...
Microsoft Excel 2016 comes with 3 office themes by default. These are light gray , dark gray and colorful theme....
When we work on SQL Server query , we use the AS keyword to specify the alias name for a...
When we want to specify a alias for a column in SQL Query , we tend to use the double...
There are multiple options to find the Windows OS Build version from command line in Windows 10. How to find...
You can find the computer name of the Windows 10 machine machine using the hostname command. The hostname command prints...
This blog post will explain in how to add prefix or suffix to a range of cells in Microsoft Excel...

Categories

Archives