Does SQL Server support XML Functions

Do any versions of SQL Server support the following functions, as
they appear in the Oracle Database:-
1) XMLElement
2) XMLAttributes
3) XMLForest
Thanks in Advance for your reply
s
Not sure about Oracle counterparts, but have you checked out the FOR XML
clause in SQL Server 2000 Books Online?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.c om...
Do any versions of SQL Server support the following functions, as
they appear in the Oracle Database:-
1) XMLElement
2) XMLAttributes
3) XMLForest
Thanks in Advance for your reply
s
|||See BOL for OPENXML and FOR XML
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.c om...
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
> s
|||In addition, SQL 2005 will make XML a first-class citizen in the server, XML
data types, XQUERY, the full ride!
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.c om...
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
> s
|||Hi,
Yep the SQL Server supports the FOR XML clause which returns the
Records/Rows as XML. However Oracle does not support FOR XML clause.
(oracle 9i). To get the output in XML format the functions that i have
mentioned have to be used.
Now before I end up using the above mentioned functions, i wanted
to know whether these functions are supported by other Databases also
or not.
Bye
Amardeep Verma
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message news:<uldgTsGeEHA.1764@.TK2MSFTNGP10.phx.gbl>...
> Not sure about Oracle counterparts, but have you checked out the FOR XML
> clause in SQL Server 2000 Books Online?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
|||FOR XML is SQL Server's T-SQL specific.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408022328.464b6cae@.posting.google.c om...
Hi,
Yep the SQL Server supports the FOR XML clause which returns the
Records/Rows as XML. However Oracle does not support FOR XML clause.
(oracle 9i). To get the output in XML format the functions that i have
mentioned have to be used.
Now before I end up using the above mentioned functions, i wanted
to know whether these functions are supported by other Databases also
or not.
Bye
Amardeep Verma
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:<uldgTsGeEHA.1764@.TK2MSFTNGP10.phx.gbl>...
> Not sure about Oracle counterparts, but have you checked out the FOR XML
> clause in SQL Server 2000 Books Online?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
|||These functions are part of the ANSI/ISO SQL-2003 standard and are not
supported in SQLServer 2005 for a variety of reasons (ISO spec was released
too late for us to add them, they are less performing and more verbose than
a rowset mapping approach such as FOR XML).
We may consider them in the next release, if enough users request them. So
please let me know if I should count you :-).
Best regards
Michael
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.c om...
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
> s