Monthly Archives: September 2016
Using DebuggerDisplay attribute in C#
DebuggerDisplay attribute class in C# lets the developer control on how an object or property needs to be displayed in the debugger variable window. Assume that you have a class that does not have th...
Quick way to search within a procedure in SQL Server
There are times when you want to to list out all the stored procedure names that contains certain keyword or search text. Here’s a simple query that helps you do that. Quick way to search withi...
How to insert a picture into a comment box in Microsoft Excel?
This blog post will explain how to add or insert picture (image) to the comment box in Microsoft Excel 2016. How to insert a picture into a comment box in Microsoft Excel? 1. Display all the comments...
How to View Named Ranges in Microsoft Excel ?
Named range is a very useful feature in Excel especially when you work with lot of formulas but there are times when you might want to view the list of all the named ranges in your workbook. There ar...
How to view the code of a stored procedure using a Query in SQL Server...
Here’s a quick tips on viewing the code of a stored procedure in SQL Management Studio. One of the quickest ways in which you can view the source code of your stored procedure is by using the sp_help...