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)

Where are full-text indexes stored?

0 Answers  

---

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

---

How to get the query of a table in sql server?

0 Answers  

---

Why use identity in sql server?

0 Answers  

---

What is the difference between a local and a global variable?

5 Answers  

---

Explain contrast amongst grouped and non-bunched records?

0 Answers  

---

How to apply filtering criteria at group level with the having clause in ms sql server?

0 Answers  

---

What is difference between inner join and join?

0 Answers  

---

What is DAC? what is the use of it?

1 Answers   Wipro,

---

What is the SQL?????????????????????????????

5 Answers   CMS,

---

What is primary key, unique key, and foreign key?

0 Answers  

---

how to change column into row in sql

4 Answers   ESS,

---