Answer Posted / pankaj kumar upadhyay

1) When we use delete command that time we will use
conditon or without conditon but when we use truncate
command so that time we will not use condition.

2)delete can roll back but truncate is not rollback.

3)Truncate is faster compare delete command.

4)delete is DML command while Truncate is DDL.

Can we deploy SSRS reports on our personal website?

162

---

What type of locking occurs during the snapshot generation? : sql server replication

1262

---

List out the differences between global and local temp tables in sql server?

1000

---

What is the difference between executequery () and executeupdate ()?

964

---

Difference between aggregate functions of sql?

1040

---

can we have a nested transaction? : Sql server database administration

992

---

What is the web service used for reporting services?

114

---

Can I use sql azure as a backup with log shipping or database mirroring?

156

---

What are the advantages of using a stored procedure?

939

---

How to write a query with a left outer join in ms sql server?

925

---

What is temporary table in sql server? Why we use temp table?

906

---

What is indexing a document?

968

---

Can we update data in a view?

969

---

What is the contrast between sql and mysql?

1049

---

How do I start sql server 2016?

857

---