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;

How to delete a login name in ms sql server?

732

---

what exactly sql injuction.how to overcome.....

2283

---

How to create a ddl trigger using "create trigger" statements?

827

---

What is the use of tempdb? What values does it hold?

769

---

How to provide login information for a new odbc dsn?

712

---

What are sub reports and how to create them?

113

---

What are the default system databases in sql server 2000?

711

---

Where is localdb stored?

752

---

What are the disadvantages of using the stored procedures?

740

---

what are the different ways to return the rowcount of a table?

761

---

What are a database and a data warehouse?

763

---

What are the five major components of a dbms?

685

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1999

---

How to download microsoft sql server 2005 express edition?

798

---

what is a correlated sub-query? : Sql server database administration

704

---