Answer / wazid ali

Blocking in SQL Server is a scenario where one connection to
SQL Server locks one or more records, and a second
connection to SQL Server requires a conflicting lock type on
the record or records locked by the first connection. This
causes the second connection to wait until the first
connection releases its locks. By default, a connection will
wait an unlimited amount of time for the blocking lock to go
away.

Answer / shyamsri83

When one transaction is trying to access a record, which is
used by other, then the first transaction has to wait,
untill the second transaction complete. This is called
blocking.

What is the difference between Procedure and Function

4 Answers   Accenture, Nagarro, TCS,

---

Explain about link server in sql server?

0 Answers  

---

What is a subquery in a select query statement in ms sql server?

0 Answers  

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

0 Answers  

---

How to turn on the mssql api module in php?

0 Answers  

---

List some major differences between triggers and stored procedures?

0 Answers  

---

Describe about first three Normal forms.

1 Answers   HP,

---

when inserting to a table how many rows will be effected using triggers

2 Answers  

---

what is Constraint? How many types of constraints in SQL ?

38 Answers   HCL, IBM, NIIT, Wipro,

---

How do you delete a data source?

0 Answers  

---

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

---

How to drop an existing user defined function in ms sql server?

0 Answers  

---