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;

what are the reporting service components in SSRS?

151

---

What is temporary stored procedure?

896

---

Does group by or order by come first?

900

---

When we should use and scope of @@identity?

952

---

Explain how dts is used to extract, transform and consolidate data?

938

---

can a table be moved to different filegroup? : Sql server administration

910

---

What is an example of a primary key?

912

---

What are the different types of join?

1100

---

explain different types of cursors? : Sql server database administration

1024

---

what is unique and xaml nonclustered index

996

---

Where are sql server usernames and passwords stored in the sql server?

1042

---

What is the difference between functions and scalar functions?

1124

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

857

---

What are a scheduled jobs?

908

---

Does sql server use t sql?

954

---