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 different types of columns types constraints in the sql server?

1072

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1052

---

What will be the maximum number of indexes per table?

947

---

optimization techinques

2665

---

Difference between connected and disconnected database in .net with sql server?

1085

---

What are sql server procedures?

967

---

What are the different types of subquery?

1144

---

How to perform key word search in tables?

953

---

What is database white box testing?

1114

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

957

---

Write an SQL query to obtain the 2nd highest salary.

1063

---

Who is the owner of a schema in ms sql server?

1067

---

Is natural join and equi join same?

961

---

What languages bi uses to achieve the goal?

996

---

Explain log shipping?

1005

---