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)

What is openrowset sql server?

0 Answers  

---

What is a trigger?

4 Answers  

---

Explain what is the difference between a local and a global temporary table?

0 Answers  

---

How to find the service pack installed? : sql server database administration

0 Answers  

---

What are indexers?

0 Answers  

---

Difference between aggregate functions of sql?

0 Answers   EXL,

---

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

---

What is a covered index?

0 Answers  

---

Can you explain some of the DTS problems?

1 Answers   UBS, Wipro,

---

what is a self join? Explain it with an example? : Sql server database administration

0 Answers  

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers  

---

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

0 Answers  

---