Which table keeps information about stored procedures?

0 Answers  

---

What is the difference between set and select?

0 Answers  

---

Why use stored procedures in sql server?

0 Answers  

---

What is the correct order of the logical query processing phases?

0 Answers  

---

Does the order of columns in update statements matter?

0 Answers  

---

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

---

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---

when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

please differentiate between delete and truncate?

0 Answers  

---

How to change a login name in ms sql server?

0 Answers  

---