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)

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

---

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

---

What is the function of inner join?

0 Answers  

---

Explain the concept of recursive stored procedure.

0 Answers  

---

How to change the name of a database user?

0 Answers  

---

---

Difference between uniqe index and uniqe constraint?

0 Answers  

---

Disadvantages of the indexes?

0 Answers  

---

What do you understand by triggers?

0 Answers  

---

How to create a view with data from multiple tables?

0 Answers  

---

How to join two tables in a single query in ms sql server?

0 Answers  

---

What happens if null values are involved in arithmetic operations?

0 Answers  

---

What is the purpose of indexing?

0 Answers  

---