Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---

The Difference between 'Count' and 'Count(*)'

13 Answers  

---

Can an automatic recovery be initiated by a user?

0 Answers  

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  

---

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

---

---

how to implement locking in sql server

3 Answers   Satyam,

---

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

0 Answers   IBM,

---

Explain the disadvantages of cursors?

0 Answers  

---

Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,

---

Explain the phases a transaction has to undergo?

0 Answers  

---

How to write a query with an inner join in ms sql server?

0 Answers  

---

How can you get @@error and @@rowcount at the same time?

9 Answers  

---