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?

Under MSSQL 2000 I get a deadlock on a transaction. This victim transaction contains one single SELECT statement joining 2 tables using the READPAST hint. I thought this hint will cause the transaction not be blocked on locks. How can it happen that the transaction is part of a deadlock? The query looks...

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/

Hi, MSSQL2000 has such a feature that it detects deadlocks and kills one of the transactions which take part in the deadlock. I would like to turn off this feature (for debugging purposes), i.e. make the server not to terminate these transactions (i.e. block forever). Is there a flag/setting in the DB...