Post Profile






How to avoid ELSE-IF Statement in stored procedure in SQL Server

In this article we have learned how to avoid code repeat and always we will try to avoid to use ELSE-IF Statment.
read more

share

Related Posts


An Experimental Performance Comparison on the Methods to Pass Structured Data to SQL Server Stored Procedures From ADO.NET

Programming / Windows Development : CodeProject

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

Exception Handling in SQL Server Stored Procedure with TRY CATCH

Programming / Windows Development : CodeProject

How to do exception handling in SQL Server Stored Procedure with Try Catch

Capture SQL Server queries fired from your Application

Programming / Windows Development : CodeProject

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...

SQL Server Stored Procedure explained with Examples

Programming / Windows Development : CodeProject

This article explains creating and using SQL Stored Procedure in SQL Server.

Stored Procedures Best Practices

Programming / Windows Development : CodeProject

CodeProject What is a Stored Procedure (SP)The stored procedure is a set of PL/Sql statements written inside a named block. We use stored procedures in Sql Server to perform the very basic operations on database tables.AdvantagesSto...

Comments


Copyright © 2016 Regator, LLC