What stored procedure would you use to view lock information?

0 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

When to use Inner join & when to use subquery?

0 Answers   IBM,

---

What is inline variable assignment?

0 Answers  

---

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

---

What are the tables in sql?

0 Answers  

---

How do you find the number of rows in a table?

7 Answers  

---

What is a trigger? Why we need it?

0 Answers   Accenture,

---

What is difference between group by and having?

0 Answers  

---

How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,

---

What is a Lock and let me know Different types of locks?

2 Answers  

---

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

---