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 is a join in sql? What are the types of joins?

1107

---

Explain what is the function of sql server agent windows service?

994

---

What is a subquery in a select query statement in ms sql server?

1131

---

what is an extended stored procedure? : Sql server database administration

1055

---

What is use of except clause? How does it differ from not in clause?

1020

---

What is #temp and @table variable in SQL server?

1090

---

Why do we use stored procedures in sql server?

940

---

How to get a list all databases on the sql server?

1102

---

What are the new features in sql server 2016?

967

---

Explain trigger classes i.e. Instead of and after trigger?

877

---

What is the contrast amongst drop and truncate?

1034

---

What is Dependency Injection and provide example?

1117

---

What is full outer join in sql server joins?

1068

---

What is an example of a primary key?

992

---

Explain primary key, foreign key and unique key?

993

---