Answer Posted / 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.

How to list all columns in a table using odbc_columns()?

937

---

What is nested transaction?

1044

---

Tell me what is normalization? Explain different forms of normalization?

983

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

935

---

How do I run a trace in sql server?

932

---

How do I debug a stored procedure in sql server?

1030

---

What is the command used to check locks in microsoft sql server?

975

---

What is an identity?

939

---

What is query optimizer in sql server?

959

---

How you can add messages to the nt event log from within a stored procedure?

998

---

What is the purpose of indexing?

1000

---

How to reaname table name without using sp_Rename in sql server..?

939

---

How do I uninstall sql server 2014?

881

---

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

887

---

What are different types of schemas?

895

---