What are the advantages of sql stored procedure?

0 Answers  

---

Explain differentiate between a having clause and a where clause?

0 Answers  

---

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

3 Answers   IBM,

---

What is surrogate key? : sql server analysis services, ssas

0 Answers  

---

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 Answers  

---

---

What happens if null values are involved in string operations?

0 Answers  

---

What is repeatable read?

0 Answers  

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

What happens if strings are casted into wrong code pages in ms sql server?

0 Answers  

---

Tell me what is use of except clause? How it differs from not in clause?

0 Answers  

---

What does REVERT do in SQL Server 2005?

0 Answers   HCL,

---

Does transparent data encryption provide encryption when transmitting data across the network?

0 Answers  

---