Visit a content portal to find information, resources, and help over a wide range of topics, projects, and issues.
By Saeid Hasani November 8, 2013
The goal of this article is to provide a simple and easy to use error handling mechanism with minimum complexity. There are many questions in the MSDN forums and other Internet communities about Error Handling in SQL Server. These are the questions: Is there any structured Error Handling mechanism in SQL Server? Is it a good idea to use a general procedure as a modular Error Handler routine? What are the benefits of THROW...
By SathyanarrayananS November 8, 2013
A few months back I wrote an article on Multi-valued Parameter as Stored procedure Input, which will work only for single character multi-valued input parameter. Now let us see an example for SSRS report with Multi-valued Parameter as Stored procedure Input, which will work in all cases. Example: Create Stored procedure in AdventureWorks database as shown in the following code block...
By John Anthony Oliver November 5, 2013
This document was originally published as an MSDN discussion. This will allow you all to suggest any changes, however small. I saw a post earlier that reminded me about Extension Methods. This led me to create the following code that acts on the base class CONTROL for ALL controls!! Using just one line of code you can transform any of your controls into the shape you want within the bounds of the original shape of the control...
By Jaliya Udagedara November 5, 2013
Probably most of you have seen the following interfaces when you write code with .NET Framework: IEnumerable, IEnumerable, IQueryable, and IQueryable. Have you ever wondered what these really are. Let’s see the beauty of them and let’s have a dig into IEnumerable and IQueryable. First let’s see how MSDN describes these four interfaces. IEnumerable: Exposes an enumerator, which supports a simple...
More featured articles