In this article we have learned how to avoid code repeat and always we will try to avoid to use ELSE-IF Statment.
This article makes an experimental comparison on the performance of the different methods to pass structured data to SQL server stored procedure parameters from ADO.NET
How to do exception handling in SQL Server Stored Procedure with Try Catch
This article describes how to create a handy tool to capture the SQL Queries, stored procedures and functions that are fired from your application. This will help developers in diagnosing the code related issues. Source Code is avai...
This article explains creating and using SQL Stored Procedure in SQL Server.