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)

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

What are the different index configurations a table can have?

0 Answers  

---

Can you move the resources after pausing the node? : sql server database administration

0 Answers  

---

Why do we need normalization?

0 Answers  

---

How will you monitor replication latency in transactional replication? : sql server replication

0 Answers  

---

How do I run sql server 2014?

0 Answers  

---

What are types of storage modes? : sql server analysis services, ssas

0 Answers  

---

Can group functions be used in the order by clause in ms sql server?

0 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

what is checksum in sql server.........???

0 Answers   TCS,

---

Explain where clause?

0 Answers  

---

What is sparse columns of sql server 2008?

0 Answers  

---