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 can sql injection be stopped? : sql server security

0 Answers  

---

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

---

Find first and last day of current month in sql server

0 Answers  

---

What is table constraint?

0 Answers  

---

Why do we need normalization?

0 Answers  

---

What is the difference between seek predicate and predicate?

0 Answers  

---

What is the synonym of join?

0 Answers  

---

Explain Different types of Projects?

1 Answers  

---

hi,i want t0 knom d syntax for a super key with an example

1 Answers  

---

I have student marks in a student table. I need second highest mark .Then what will the query for this?

37 Answers   NetCore, Patni, SAP Labs, Temenos, Wipro,

---

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  

---

How to get the definition of a trigger back?

0 Answers  

---