How to create a scrollable cursor with the scroll option?

0 Answers  

---

What is NOT NULL Constraint in sql server 2012?

0 Answers   CDC,

---

What is recompile sql server?

0 Answers  

---

Explain the truncate command? : SQL Server Architecture

0 Answers  

---

Do you know the capabilities of cursors?

0 Answers  

---

---

Explain about local stored procedure?

0 Answers  

---

What is the difference between functions and scalar functions?

0 Answers   EXL,

---

How can you find out which stored procedures are recompiling?

0 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  

---

How can we delete Duplicate row in table?

0 Answers   Wipro,

---

What is the difference between varchar and nvarchar datatypes?

0 Answers  

---

Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

---