Answer Posted / a

int

What is the difference between char and varchar2 datatype in sql?

1066

---

What is the difference between varchar and nvarchar datatypes?

1087

---

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1046

---

Where can you add custom error messages to sql server?

1123

---

How to create a trigger for insert only?

1038

---

What is buffer cash in sql server?

1152

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1089

---

What are the key configuration files for sql server reporting services ?

167

---

what is blocking? : Sql server database administration

1041

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1000

---

What is the definition for sql server 2000?

1089

---

What is an execution plan? When would you use it?

978

---

How connect excel to sql server?

995

---

What are the properties of the relational tables?

881

---

What is table value parameters (tvp)?

1101

---