About Indexed Views? with example? plz reply...

2 Answers  

---

Tell me what are the advantages of using stored procedures?

0 Answers  

---

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

---

How do I view a stored procedure in sql server?

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

Tell me about Triggers?

3 Answers   Cap Gemini,

---

Can a database be shrunk to 0 bytes, if not, why?

0 Answers  

---

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

---

What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

What are a scheduled jobs?

0 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details?

0 Answers  

---

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

---