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?

Yes.but My Question is - "is there anyway to avoid Rollbacking of inner transactions alone??"

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/

what is the diffrence in DBMS and RDBMS?