Answer / naren

New data type XML, Binary
SSIS,SSRS,SSAS

Answer / 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.

Explain triggers?

0 Answers  

---

Explain trigger and trigger types?

0 Answers  

---

How can I check that whether automatic statistic update is enabled or not?

0 Answers  

---

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

0 Answers  

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---

what are batch in sql server?

2 Answers   Satyam,

---

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

---

What are the characteristics of modern DBMS?

0 Answers   Ericsson,

---

Define views.

0 Answers  

---

What is difference between rownum and rowid?

0 Answers  

---

What is the Difference beween sql server 2005 and sql server 2008

3 Answers   CMC, Hitech,

---

How to provide login information for a new odbc dsn?

0 Answers  

---