Answer / Abhinav Gaur

DELETE removes rows from a table based on selection criteria, while TRUNCATE TABLE eliminates all records in a table without regards to any specific conditions. Additionally, DELETE preserves the table structure and allows the use of transactions, whereas TRUNCATE TABLE does not support transactions.

Give me a SQL Query to find out the second largest company?

1 Answers   Ernst Young,

---

What is transaction server implicit?

1 Answers  

---

What is sql server agent and what are the two modes of authentication in sql server?

1 Answers  

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1 Answers  

---

List the ways in which dynamic sql can be executed?

0 Answers  

---

Explain data warehousing in sql server?

1 Answers  

---

Can group by and orderby be used together?

1 Answers  

---

What is sql server database?

1 Answers  

---

Define model database?

1 Answers  

---

What is the difference between HAVING clause and the WHERE clause?

7 Answers  

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1 Answers   Genpact,

---

Tell me the difference between clustered and non-clustered index?

1 Answers  

---