sql server enterprise edition 2008 r2

MICROSOFT SQL SERVER COMPACT 3.5 WITH SERVICE PACK 2

sqlserver 2008 r2 enterprise edition

MICROSOFT SQL SERVER COMPACT 3.5 WITH SERVICE PACK 2

whether it is optable for very large xml file?

thank u...you helped me a lot..:-)

one more query....

now in case i want to update my xmlfile i.e i want to add an <result> after <abstract>...how do i perform?

if i want...

Bunch of thanks for your fast reply....

1.2008 r2

2.don hav XSD file..

suppose if we index an Xml data....how do we can view those indexes????

CREATE DATABASE pap17

GO

USE pap17

GO

CREATE TABLE paptable17

(

Id INT IDENTITY PRIMARY KEY,

XMLData XML,

LoadedDateTime DATETIME

)

INSERT INTO paptable17(XMLData, LoadedDateTime)

SELECT CONVERT(XML, BulkColumn) AS BulkColumn, GETDATE()

FROM OPENROWSET(BULK 'D:\test.xml', SINGLE_BLOB) AS x;

SELECT * FROM paptable17

while clicking...