How do SQL server 2000 and XML linked?

Question Posted / latha sree

2 Answers
7464 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do SQL server 2000 and XML linked?..

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'

Is This Answer Correct ?

1 Yes

0 No

How do SQL server 2000 and XML linked?..

Answer / raghu

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

Is This Answer Correct ?

0 Yes

1 No

Post New Answer