Re: Inserting XML String to a Text datatyped column
From: Michael Rys [MSFT] (mrys_at_online.microsoft.com)
Date: 02/20/04
- Next message: Michael Rys [MSFT]: "Re: Using XPath Queries to filter result sets"
- Previous message: Mark W: "Re: Using XPath Queries to filter result sets"
- In reply to: Varma Alluri: "Inserting XML String to a Text datatyped column"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 20 Feb 2004 00:17:51 -0800
In SQLServer 2000, you can only send this back via OLEDB/ADO. So if you want
to get this into the server, you either write an ADO/OLEDB program that
retrieves and sends it back or use the sp_OA stored procedures to drive it
from within a stored procedure.
In Yukon, you will be able to store it as either a string or XML datatype
directly.
Best regards
Michael
"Varma Alluri" <Varma.Alluri@Ultralink.com> wrote in message
news:12aa901c3f721$30b62250$a301280a@phx.gbl...
> Hi SQL Gurus,
>
> I have an XML question to which I am kind of new.
>
> I have an XML string that I get by using a query similar
> to the following....
>
> SELECT 1 AS Tag,
> NULL AS Parent,
> NULL AS [Zip_ROOT!1!],
> NULL AS [Zip!2!Value!element],
> NULL AS [Zip!2!State!element]
> FROM ZipCodes
> UNION
> SELECT 2,
> 1,
> NULL,
> Zip,
> State
> FROM ZipCodes where id < 3
> FOR XML EXPLICIT
>
> This returns an XML string, which is very long. I need to
> take this string and INSERT/UPDATE to a Text column in a
> table.
>
> Any kind of help in this regard will be grately
> appreciated.
>
> Regards,
> Varma
>
>
- Next message: Michael Rys [MSFT]: "Re: Using XPath Queries to filter result sets"
- Previous message: Mark W: "Re: Using XPath Queries to filter result sets"
- In reply to: Varma Alluri: "Inserting XML String to a Text datatyped column"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
