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 the Control Flow in SSIS

0 Answers   HCL,

---

what is database replicaion? : Sql server database administration

0 Answers  

---

What is a trigger and its types?

0 Answers  

---

List the different types of collation sensitivities in sql server?

0 Answers  

---

Explain temporary table vs table variable by using cursor alternative?

0 Answers  

---

---

What is the filtered index?

0 Answers  

---

Name few of the dcl commands in sql?

0 Answers  

---

What are the different types of sql server replication? : sql server replication

0 Answers  

---

What is the xml datatype?

0 Answers  

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

Explain what is cte (common table expression)?

0 Answers  

---

What is function of ROLLUP ?

0 Answers   HCL,

---