What is the difference between delete and truncate statements?

0 Answers  

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

---

What is Extended user-defined?

0 Answers  

---

Which system table contains information on constraints on all the tables created?

2 Answers  

---

What command is used to rename the database?

0 Answers  

---

---

What are the advantages of having an index on the sql server?

0 Answers  

---

what are the types of indexes? : Sql server database administration

0 Answers  

---

Explain features of analysis services?

0 Answers  

---

what is the difference between table and view

1 Answers  

---

What is outer join in sql server joins?

0 Answers  

---

What is inner join? Explain with an example?

0 Answers  

---

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers   Accenture, IBM, Marlabs,

---