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

930

---

How we can compare two database data?

998

---

Explain aggregate functions?

1141

---

What is self contained multi valued query?

1075

---

What is explicit mode in sql server?

1109

---

What is logon trigger?

1160

---

How to Update from select query in sql server?

1118

---

What is system stored procedures?

1085

---

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

1041

---

What is repeatable read?

1093

---

What is a rollup clause?

1018

---

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

996

---

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

1063

---

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

1081

---

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

1126

---