Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How do SQL server 2000 and XML linked?

Question Posted / latha sree

Answers were Sorted based on User's Feedback



How do SQL server 2000 and XML linked?..

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;

Is This Answer Correct ?    1 Yes 0 No

How do SQL server 2000 and XML linked?..

Answer / raghu

SQL Server can be connected with XML through IIS(Internet
information services)

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is sql collation?

0 Answers  

Why main is user defined function?

0 Answers  

What is isnull() operator?

0 Answers  

Write a query to find 5th highest amount paid from the customer table.

0 Answers  

What are the main sources of data?

0 Answers  

Does table partitioning improve performance?

0 Answers  

Can you give an example of Stored Procedure?

4 Answers   Wipro,

What is the datatype returned by count(*)

22 Answers   247Customer, Asian CERC,

WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  

Can you index views?

0 Answers  

Where are sql server user names and passwords stored in sql server?

0 Answers  

How to invoke a trigger on demand?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories