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

Answer / raghu

SQL Server can be connected with XML through IIS(Internet
information services)

How check triggers in sql server?

0 Answers  

---

How to delete existing triggers using "drop trigger"?

0 Answers  

---

What is normalization and what are the different forms of normalizations?

2 Answers  

---

How to rebuild master databse?

0 Answers  

---

What r sql reporting services and analysis services? how can we use it.

2 Answers   Microsoft,

---

What command would you use to add a column to a table in sql server?

0 Answers  

---

How fixed length strings are truncated and padded?

0 Answers  

---

What is the difference between commit and rollback?

0 Answers  

---

List the different types of collation sensitivities in sql server?

0 Answers  

---

Equi join and non equi join is possible with sql server?

0 Answers  

---

What are the steps you must follow to hide sql server instances?

0 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---