Answer Posted / sakthi

for error handling in 2005 we use try catch, new functions
like pivot and unpivot, datatype nvarchar(max), varchar
(max), char(max) to handle xml in 2005 we have special
datatype caller XML.

What are the basic features of a trigger in ms sql server?

1194

---

What is 'write-ahead log' in sql server 2000 ?

1057

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1002

---

Write a query for primary key constraint with identity key word?

1031

---

How to get the definition of a stored procedure back?

977

---

What is resultset concur_updatable?

1021

---

Is INSTEAD OF trigger directly applicable to Table ?

1017

---

How to add code to the existing article (using improve article)?

1110

---

List types of tables in SQL Azure?

126

---

1 01 101 01010

2055

---

How do I open port 1433?

932

---

Which Model uses the SET concept

985

---

How do use Having,Group by,Group function in SQL?

1746

---

What are the different types of subquery?

1160

---

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

881

---