Answer Posted / debasish

in 2005--database mirroring,CLR Integarion,SIS,Data
paratition, xml datatype,Dynamic management views,Mirror
backup

there is no sqlserver2002 hope so

How to execute a sql statement using mssql_query()?

989

---

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

1279

---

What is a rownum?

907

---

What is the difference in accessing db between sql server vs sql azure?

174

---

What is the difference between truncate and delete commands?

1013

---

What is sql server english query?

1053

---

What are different types of constraints?

882

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

917

---

What are orphan records?

894

---

What are subqueries in sql server?

1070

---

What is usually the first word in a sql query?

1077

---

Does index speed up select statements?

984

---

Give me any three differences between Truncate and Delete.

1054

---

How to use old values to define new values in update statements in ms sql server?

1189

---

What are the general features of sql server management studio? : sql server management studio

1029

---