What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

Name three version of sql server 2000 and also their differences?

1 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

Can we have more than one NULL in a column having unique constraint?

12 Answers   247Customer,

---

What is a scheduled job or what is a scheduled task?

0 Answers  

---

how can i view structure of table in sql server? tell me that query.

10 Answers  

---

Explain what is the difference between a local and a global temporary table?

0 Answers  

---

SQL Server Architecture ?

0 Answers   IBM, Sapient,

---

What are information schema views?

0 Answers  

---

What are Spatial data types in SQL Server 2008

0 Answers   Infosys,

---

Explain the microsoft sql server delete command?

0 Answers  

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  

---