Using TRY-CATCH to Rollback a Transaction in SQL Server

Hello Mates,
Today I am going to buzz on Error Handing in Sql Server 2005.

The release of Sql Server 2005 has provided us somany features over its predecessor. No doubt that more preference is given to the tasks performed by the administrator. But there are some new development features added to make your Sql Code more powerful and error resistance, specially; Stored Procedures. Read More…

Passing lists to SQL server stored procedures

Check out my article on “Passing lists to SQL server stored procedures”.

The Article is about the ability to pass “a list of values” from .Net as a parameter to a T-SQL based stored procedure.

There are lots of scenarios where we need to pass a list of values to save in database.. Read More…