Tag: tricks
How to Declare a variable in SQL Server ?
You will most likely declare a variable in the SQL Server and use it in the SQL Statements. You can use the DECLARE statement and specify the variable and datatype and optionally provide a default value. For example , You can declare an NewEmployeeJobTitle variable using the DECLARE statement and provide a default value as ‘Chief Executive Officer’ DECLARE @NewEmployeeJobTitle nvarchar(50) = ‘Chief Executive Officer’;…
How to Declare and Define an unsigned short data type variable in F# ?
How to Declare and Define an unsigned short data type variable in F# ?
How to Open Network Connections from Command line in Windows 10 ?
You can use the ncpa.cpl command to open the network connections from command line in Windows 10. How to Open Network Connections from Command line in Windows 10 ? Just open the command window and type ncpa.cpl and press the enter key to open the network connections dialog. Alternatively , the ncpa.cpl command can also be used in the Run window. Press Windows + R…
How to Declare and Define an Short data type variable in F# ?
How to Declare and Define an Short data type variable in F# ?
How to Check if a login exists in SQL Server ?
If you need to check if a login exists in SQL Server , you can use query the master.dbo.syslogins for it. How to Check if a login exists in SQL Server ? Here’s a sample query demonstrating how you can query master.dbo.syslogins to find out if the login exists in SQL Server. This would retreive all the details of the loginid ‘sa’.
How to Declare and Define an String data type variable in F# ?
How to Declare and Define an String data type variable in F# ?
How to Save a Stream to a File in C# ?
Below is a sample code snippet that demonstrates how to save a stream to a file in C#. How to Save a Stream to a File in C# ?
How to change positive numbers to negative in Microsoft Excel 2016 ?
Do you want to change the positive numbers to negative numbers and vice versa (or in simple terms) , reverse the sign of the numbers in Microsoft Excel 2016 ?. This blog post will provide you a simple tip on how to do it using the Paste special function. How to change positive numbers to negative in Microsoft Excel 2016 ? 1. Type the number…
C# 6.0 feature – Lambda Expression in Function Members
C# 6.0 lets the developers to use lambda expression as function member . For example , instead of the function body , you can write the lambda expression directly as shown below. C# 6.0 feature – Lambda Expression in Function Members
Using BETWEEN clause to specify range of values in SQL Query
In SQL Server 2014 , you can use the BETWEEN clause to specify a range of values in the search criteria. How to specify a range of values in a Query in SQL Server ? For example , you want to to query the Employee table to display the employees having the birthdate between 1969-01-29 and 1975-12-01′ , you can use the BETWEEN clause as…
How to return rows in random order in SQL Server ?
Do you want to return rows sorted in random order , here’s how you do it. How to return rows in random order in SQL Server ? This example demonstrates how to sort the Employee table and display the results in random order.
How to Prevent the Lock Screen to automatically lock from the Windows Phone 8 App?
There are times when the automatic lock of the Screen is enabled by the user in the Settings App of the Windows Phone 8. When your App is running on the device, sometimes you may not want to lock the device automatically for various reasons . How to Prevent the Lock Screen to automatically lock from the Windows Phone 8 App? Below is a sample…