Alternative to OpenXML

Hi Shilpa,
I think that the best way for to do it is with OPENXML like you said:

OPENXML
OPENXML is a Transact-SQL keyword that provides a relational/rowset view
over an in-memory XML document. OPENXML is a rowset provider similar to a
table or a view. OPENXML provides a way to access XML data within the
Transact-SQL context by transferring data from an XML document into the
relational tables. Thus, OPENXML allows you to manage an XML document and
its interaction with the relational environment.

OPENXML can be used in statements such as SELECT, INSERT, UPDATE, and
DELETE. Instead of specifying a source table or a view, OPENXML can be
specified.

An XML document can be passed to a stored procedure as text parameter (char,
nchar, varchar, nvarchar, text, ntext). The OPENXML statement can be used
along with other Transact-SQL statements to provide a rowset view of the XML
data so that relational operations such as insert, update, delete, and joins
can be performed with an XML document as the source. This can be used to
perform multirow, multitable updates to the database using a single stored
procedure invocation.

Please find enclosed an article:

http://www.microsoft.com/technet/pr...l.mspx#EGD

Best regards,

"Shilpa" wrote in message
news:

Hi,

I want to entere data in xml into tables in the database.
Howevere, I do not want to use OpenXML
Please let me know if there is an alternative.

Regards,
Shilpa