Answer Posted / anand

yes,we can ROLLBACK records deleted by truncate if we had
executed BEGIN TRAN first
ex:

Begin Tran
truncate table tablename
ROLLBACK

with out "Begin Tran" you can not rollback

What is left outer join in sql server joins?

1039

---

What is query cost in sql server?

995

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1021

---

What is difference between line feed ( ) and carriage return ( )?

901

---

How to defragment table indexes?

987

---

What is log cache in sql server?

1038

---

What is dknf in normalization form?

1052

---

How to reaname table name without using sp_Rename in sql server..?

989

---

What is data modeling and Reterminal integrity?

1955

---

Tell me about the approaches which you used to counter the DI problems.

1348

---

Which sql server table is used to hold the stored procedure scripts?

1061

---

What is nolock?

980

---

Can I disable or restrict ssrs export formats (rendering formats)?

150

---

How to call a function from a stored procedure in SQL Server ?

1027

---

What is the difference between lock, block and deadlock? : sql server database administration

1043

---