Answer Posted / nageswarao

truncate is used for deleting all data from table.
it is similar to delete command without condition.
main differences b/w delete & truncate are
1.truncate is faster in execution than delete which will
restructure the complete table without bothering of data.
where as delete checks the data row by row wrotes
information into log and deletes.
2.with truncate we cannot use any conditions

How to provide values to stored procedure parameters in ms sql server?

973

---

What is the difference between for trigger and after trigger?

1022

---

Why olap is used?

913

---

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1902

---

What are the different kinds of ssrs reports?

206

---

What is dimension table? : sql server analysis services, ssas

968

---

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

951

---

What are the restrictions applicable while creating views? : SQL Server Architecture

978

---

What is logshipping and its purpose?

942

---

Is mysql better than sql server?

1000

---

How to connect to SQL Azure Database by using sqlcmd?

136

---

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1087

---

Explain active/passive and active/active cluster configurations?

1013

---

What is difference between global temporary tables and local temporary tables?

1175

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1014

---