How is table type constraint applied to a table?

0 Answers  

---

What are the options which must be set to allow the usage of optimistic models?

0 Answers  

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,

---

what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

---

what are file groups?

3 Answers   Evalueserve,

---

---

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  

---

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

---

what is a stored procedure and trigger?

3 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers  

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

0 Answers  

---

Explain important index characteristics?

0 Answers  

---

please differentiate between delete and truncate?

0 Answers  

---