Answer / swapna

Blocking happens when one connection from an application
holds a lock and a second connection requires a conflicting
lock type. This forces the second connection to wait,
blocked on the first

Answer / rajendra kumar

Select Blocked from Master..sysprocesses Where Blocked <>0

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

Explain about system database?

0 Answers  

---

Is mysql better than sql server?

0 Answers  

---

Explain different types of locks in sql server.

0 Answers  

---

Explain the phases a transaction has to undergo?

0 Answers  

---

---

Does transparent data encryption provide encryption when transmitting data across the network?

0 Answers  

---

What is self contained sub query?

0 Answers  

---

How to write an inner join with the where clause in ms sql server?

0 Answers  

---

what is the system function to get current user's user id? : Sql server database administration

0 Answers  

---

what are default? Is there a column to which a default cant be bound?

1 Answers  

---

What is difference between rollback immediate and with no_wait during alter database?

0 Answers  

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

0 Answers  

---