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

879

---

How we can compare two database data?

940

---

Explain aggregate functions?

1078

---

What is self contained multi valued query?

1010

---

What is explicit mode in sql server?

1056

---

What is logon trigger?

1091

---

How to Update from select query in sql server?

1059

---

What is system stored procedures?

1040

---

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

992

---

What is repeatable read?

1011

---

What is a rollup clause?

967

---

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

951

---

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

1008

---

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

1032

---

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

1073

---