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 SQL Server?

1148

---

How to copy the tables, schema and views from one sql server to another?

990

---

What is Lock table in SQL?

1410

---

What is multi-statement table-value user-defined function?

935

---

Explain Geography datatype in SQL Server

1060

---

What are the differences between lost updates and uncommitted dependencies?

1012

---

Why variables called the most powerful component of ssis?

1026

---

How to rename databases in ms sql server?

1126

---

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1025

---

How to find which stored procedure is currently running in sql server?

925

---

What is a view and what are its advantages?

1053

---

What is the use of stored procedure?

893

---

Why it is recommended to avoid referencing a floating point column in the where clause?

919

---

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

1268

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

978

---