Answer / 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;

Answer / raghu

SQL Server can be connected with XML through IIS(Internet
information services)

What are the results of running this script?

0 Answers  

---

Can we take the full database backup in log shipping?

0 Answers  

---

How to find which stored procedure is currently running in sql server?

0 Answers  

---

Please differentiate between a local and a global temporary table?

0 Answers  

---

Explain isolation levels that sql server supports?

0 Answers  

---

Is the primary key column of a table an index in ms sql server?

0 Answers  

---

Can a unique index be created on a column, which contains null?

0 Answers  

---

Explain about Normalization?

0 Answers   Infosys,

---

What is the difference between having and where clause?

4 Answers  

---

What is partition index in sql server?

0 Answers  

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

0 Answers  

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

0 Answers  

---