How do SQL server 2000 and XML linked?
Answers were Sorted based on User's Feedback
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'
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / raghu
SQL Server can be connected with XML through IIS(Internet
information services)
| Is This Answer Correct ? | 0 Yes | 1 No |
How can sql injection be stopped? : sql server security
Can the query output be sorted by multiple columns in ms sql server?
Find first and last day of current month in sql server
What is table constraint?
Why do we need normalization?
What is the difference between seek predicate and predicate?
What is the synonym of join?
Explain Different types of Projects?
hi,i want t0 knom d syntax for a super key with an example
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.........
How to get the definition of a trigger back?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)