Answer Posted / hcl

Its linked in so many ways..To generate the output in xml
format to load the XML data into SQL Server tables.

To generate the XML data using select statement can have ,
"for XML {RAW/AUTO/EXPLICIT)" option added in the last of
sql server >=2000 (not possible in <2000).



example is

use Northwind

select * from orders where orderID in (10248, 10249) for
xml auto

Result:

<orders OrderID="10248" CustomerID="VINET" EmployeeID="5"
OrderDate="1996-07-04T00:00:00"
RequiredDate="1996-08-01T00:00:00"
ShippedDate="1996-07-16T00:00:00" ShipVia="3"
Freight="32.3800" ShipName="Vins et alcools Chevalier"
ShipAddress="59 rue de l&apos;

What is importing utility?

1038

---

What is user defined stored procedures?

993

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

2008

---

Mention the 3 ways to get a count of the number of records in a table.

1025

---

Explain how to integrate the ssrs reports in application?

1063

---

Is truncate a dml command?

999

---

List types of tables in SQL Azure?

128

---

What are the differences between sql server and mysql.

1139

---

What is tablix?

169

---

What is a field in a table?

1071

---

What encryption security is available in sql azure?

101

---

How to sort query output in descending order in ms sql server?

985

---

Explain datetime2 data type in sal server 2008?

951

---

Do you know what are the differences between lost updates and uncommitted dependencies?

1137

---

How will you hide an attribute? : sql server analysis services, ssas

1011

---