|
Home > Archive > MS SQL XML > January 2006 > SQL 2005 Stored Procedure XSLT Scalar
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL 2005 Stored Procedure XSLT Scalar
|
|
| Karl Mikesell 2006-01-18, 11:24 am |
| Using native SQL 2005 datatype XML data type in table, is it possible for a
Stored Procedure to return a scalar value of the transformed xsl of column
(XML).
The data is stored as XML, and the XSL is also stored as XML, but how to
return result as scalar?
| |
| Michael Rys [MSFT] 2006-01-18, 1:23 pm |
| I am not quite sure what you are looking for....
You can use XML typed output parameters. But side effects are always
returned as rowsets (even if it only exactly contains one value).
You may want to look into using a user-defined function instead of stored
proc.
And the XSLT can be applied using CLR user-defined functions.
Best regards
Michael
"Karl Mikesell" <multisy@ieee.org> wrote in message
news:u2U1xtEHGHA.3984@TK2MSFTNGP14.phx.gbl...
> Using native SQL 2005 datatype XML data type in table, is it possible for
> a Stored Procedure to return a scalar value of the transformed xsl of
> column (XML).
>
> The data is stored as XML, and the XSL is also stored as XML, but how to
> return result as scalar?
>
|
|
|
|
|