Answer / v.krishnakumar

in truncate we can delete inside the table data not the
structure of the table,in delete operation we can remove
our data in the table as well as structure but we can get
again using rollback operation, in drop operation it was
permanentely removed from our database we cannot get agian.

Answer / aman sharma

truncate are the use to the remove the data as well all the space into the table , and the delete are use to the delete only for the data into the table,and the drop is use to the delete or remove the table....

How do I create a stored procedure in dbml?

1 Answers  

---

What is sql server replication? : sql server replication

1 Answers  

---

what do you understand by change data capture?

1 Answers  

---

What are commit and rollback in sql?

1 Answers  

---

Explain Trigger with an example?

2 Answers  

---

What are the dmvs?

1 Answers  

---

List out different types of normalizations in sql server and explain each of them?

1 Answers  

---

What is the sql server agent?

1 Answers  

---

query processing

1 Answers  

---

What are the different types of cursor?

1 Answers   HCL,

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

3 Answers   Microsoft,

---

how can i lock the column in the table

2 Answers   Accenture,

---