Answer Posted / swapnareddy

Main Differences between Truncate and Delete:
Truncate:
1:Truncate removes all records but using this we cannot
remove a particular record.
2:Truncate is ddl command(data definiton language command)
3:Rollback cannot be done when we use this command.
4:Truncate cannot fire a trigger.
Delete:
1:delete can remove all records or a particular record.
2:delete is a dml command(data manipulation language command)
3:rollback is possible when we use this command.
4:delete can fire a trigger

How to use transactions efficiently : transact sql

1006

---

Can I join the same table twice?

1006

---

What is sqlite format?

1129

---

What are the different ddl commands in sql?

1087

---

what is 'mysqladmin' in mysql? : Sql dba

987

---

What are sql ddl commands?

1051

---

explain advantages of myisam over innodb? : Sql dba

1030

---

Can we edit a view in sql?

937

---

Can we rollback after truncate?

998

---

What are the operators used in select statements?

1015

---

Define overloaded procedure?

1028

---

What is sharding in sql?

933

---

how to create a new table in mysql? : Sql dba

949

---

what is the difference between blob and text? : Sql dba

977

---

What will you get by the cursor attribute sql%notfound?

1029

---