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

What is the difference between Stored Procedures and triggers?

1074

---

What are the types of subscriptions in SQL Server replication?

1022

---

Can we add a cpu to sql server?

998

---

What is the difference between locking and multi-versioning?

981

---

What is extended stored procedures?

950

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

954

---

What is transaction server auto commit?

1056

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1004

---

How to end a stored procedure properly in ms sql server?

1073

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1114

---

What are the types of table?

974

---

what is bit datatype? : Sql server database administration

904

---

Do you know what is openxml in sql server?

1063

---

Write a sql query to delete duplicate records from a table called table1

1021

---

Introduction of rollup clause using sum and group by clause?

947

---