Which are the new data types introduced in sql server 2008?

932

---

How we can compare two database data?

998

---

Explain aggregate functions?

1141

---

What is self contained multi valued query?

1076

---

What is explicit mode in sql server?

1111

---

What is logon trigger?

1163

---

How to Update from select query in sql server?

1123

---

What is system stored procedures?

1089

---

What is sql injection? How to protect against sql injection attack?

1044

---

What is repeatable read?

1094

---

What is a rollup clause?

1019

---

How can I know what locks are running on which resource?

999

---

When I delete any data from a table, does the sql server reduce the size of that table?

1064

---

What is user-defined functions? What are the types of user-defined functions that can be created?

1086

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1126

---