MSSQLTips

How to write stored procedures in SQL Server? Please Send the Description with examples of stored procedures. How many types of stored procedures are there in SQL Server for INSERT,UPDATE,DELETE? How to call procedures?

I am having doubt - is it achivable Or not? The senario is , "If the outer transaction is rolled back, then all inner transactions are also rolled back" is it any way to avoid Rollbacking of inner transactions?? Thanks, srinivasan r

Dear members, we provide a solution of bugs related to sql server along with study material and interview preparation of SQL server. click below link to get your solution http://mssqlinterview.blogspot.com/