How to recompile stored procedure at run time?

0 Answers  

---

Can you roll back the ddl statement in a trigger?

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

what is difference between primary key and Unique

8 Answers  

---

Explain query editor regions

0 Answers  

---

---

Can we do dml on views?

0 Answers  

---

How to change server name in sql server?

0 Answers  

---

How can I know what locks are running on which resource?

0 Answers  

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

What are the 3 types of schema?

0 Answers  

---

What is the contrast between sql and mysql?

0 Answers  

---

Explain about protocol layer present in SQL server?

0 Answers  

---