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 override dml statements with triggers?

1166

---

How is sql used in sql server?

997

---

What is built-in function?

992

---

What do you mean by stored techniques? How would we use it?

1022

---

how to define testing of network layers? : Sql server database administration

960

---

List the different types of collation sensitivities in sql server?

1036

---

What is the purpose of floor function?

1027

---

What are the restrictions that views have to follow? : SQL Server Architecture

983

---

Explain what is scheduled job and how to create it?

944

---

Why do we use functions?

902

---

What is dynamic cursor in SQL SERVER?

1069

---

Explain acid?

1069

---

How do you run a trace?

891

---

How do I find the size of a sql server database?

914

---

What is the sql profiler?

933

---