What are dml (data manipulation language) statements in ms sql server?

0 Answers  

---

Define indexes?

0 Answers  

---

How you can change the database name in SQL SERVER?

0 Answers  

---

How many database files are there in sql server 2000?what are they?

0 Answers  

---

What is Check point? Explain in Brief what it will do?

1 Answers   Wipro,

---

---

When is update_statistics command used?

0 Answers  

---

What are the types of constraints?

1 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

0 Answers  

---

How can I enforce to use particular index?

1 Answers   Symphony,

---

When you use @@error and try-catch?

0 Answers  

---