Answer / jay

Below is a quick recipe for a dead lock. Two transactions,
one first updating table 1, then 2 and the other one doing
it in reverse order.

Both transactions wait in the middle for 20 seconds to give
you some time to execute them 'simulaneously'.

When you run the two in transactions in two windows 'at the
same time', you'll only have to wait ~20 seconds, and one of
the windows will experience a dead lock.




CREATE TABLE t1 (i int);
CREATE TABLE t2 (i int);

INSERT t1 SELECT 1;
INSERT t2 SELECT 9;


/* in one window enter: */
BEGIN TRAN
UPDATE t1 SET i = 11 WHERE i = 1
WAITFOR DELAY '00:00:20'
UPDATE t2 SET i = 99 WHERE i = 9
COMMIT

/* in a second window (another transaction) enter: */
BEGIN TRAN
UPDATE t2 SET i = 99 WHERE i = 9
WAITFOR DELAY '00:00:20'
UPDATE t1 SET i = 11 WHERE i = 1
COMMIT

What is sql server used for?

0 Answers  

---

Explain transaction server distributed transaction?

0 Answers  

---

What is nonclustered index on computed columns?

0 Answers  

---

What is data mart? : sql server analysis services, ssas

0 Answers  

---

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

---

How to create a store procedure with encryption?

0 Answers  

---

What are the database objects? : SQL Server Architecture

0 Answers  

---

Explain primary key?

0 Answers  

---

When cursors are useful?

0 Answers  

---

Which stored procedure will you be running to add a linked server?

1 Answers  

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

What command do we use to rename a db?

5 Answers   IBM,

---