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 types of replication are supported in sql server? : Sql server database administration

459

---

How to create hyperlink from returned sql query ?

618

---

What are acid properties of transaction?

549

---

How to check if stored procedure is running in sql server?

481

---

Write a sql query to get zero records from a table having n number of records?

705

---

---

What does REVERT do in SQL Server 2005?

558

---

When you use @@error and try-catch?

570

---

what's the information that can be stored inside a bit column? : Sql server database administration

527

---

Define compound operators?

532

---

Do you know what is sql service broker?

530

---

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

117

---

What is a trigger? Why we need it?

529

---

What is normalization 1nf 2nf 3nf?

628

---

In case you have filters in your report, when filters will be applied in cached report instance?

79

---

Can we add a cpu to sql server?

517

---