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 is a document index?

0 Answers  

---

default databases available in sql server and there uses ?

4 Answers   TCS,

---

What is a join and their types?

2 Answers   Challenger Financial,

---

Can you name a few encryption mechanisms in sql server?

0 Answers  

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

---

What do you need to connect php to sql server?

0 Answers  

---

What is normalization process?

0 Answers  

---

What do you mean by data integrity?

0 Answers  

---

What is the significance of master, tempdb and model databases?

0 Answers  

---

How do I start sql server?

0 Answers  

---

When do you think a developer should use sql server-based cursors?

0 Answers  

---

What are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---