Home2016Page 3

2016

Showing 41 - 60 of 146 results
The code snippet shown in this blog post demonstrates how you can get the enumeraor from a range of elements...
In C# , we can use the out parameters to get the behavior of the call by reference. In the...
There are times when you might have a column names in your SQL Server database table that might looks like...
DebuggerDisplay attribute class in C# lets the developer control on how an object or property needs to be displayed in...
When working in ADO.NET for data access , there are times when you want to check to see if a...
You can easily return all the column names of a table in SQL Server 2008 using the sp_columns stored procedure....
SQL Server provides an function ISNULL if the value placed in the 2nd parameter if the first parameter passed to...
There are times when you want to to list out all the stored procedure names that contains certain keyword or...
This blog post will explain how to add or insert picture (image) to the comment box in Microsoft Excel 2016....
  • Excel
  • September 2, 2016
Named range is a very useful feature in Excel especially when you work with lot of formulas but there are...
  • Excel
  • September 1, 2016
Here’s a quick tips on viewing the code of a stored procedure in SQL Management Studio. One of the quickest...
When working with SQL Management studio , you might need to display a string N number of times , in...
Assume that you have a date “01/09/2016” and you would like to find out what day of the week it...
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...

Categories

Archives