How to delete all rows with truncate table statement in ms sql server?

0 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

What is instead of dml trigger?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers  

---

What is difference between unique and primary key?

0 Answers  

---

Can we use max in where clause?

0 Answers  

---

Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,

---

Do you know what are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

---

What is Deadlock?

4 Answers   Satyam,

---

How you can get the list of largest tables in a database?

0 Answers  

---

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

---