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;

Explain rdbms?

985

---

What are audit control procedures?

947

---

What are the different types of indexes?

1053

---

What do we need queues in sql service broker?

1015

---

What is the difference between a function and a stored procedure?

1021

---

Can you pass expressions to stored procedure parameters?

980

---

What are the operating modes in which database mirroring runs?

1041

---

What is difference between rownum and rowid?

862

---

What is a file group?

1029

---

Give main differences between "Truncate" and "Delete".

1039

---

What are types of subqueries?

1007

---

How do I run sql server 2014?

943

---

How to remove duplicate rows from table?

1175

---

Explain query editor regions

1009

---

How can we rewrite sub-queries into simple select statements or with joins?

933

---