| Li-fan Chen 2006-11-20, 7:21 pm |
| http://support.microsoft.com/kb/555266
Li-fan Chen wrote:
> Hi,
>
> While working on a large asp.net project we have had the great pleasure
> of using SQL Server 2005. Unfortunately not all of the asp.net projects
> could be upgraded to 2.0 (to match the new database) and we are a little
> confused about how to access the large data types introduced in SQL
> Server 2005.
>
> One of the feature is XML datatypes. We have some questions about
> feeding SQL Server xml datatypes and retrieving xml datatypes:
>
> IN-BOUND
>
> How should we phrase the System.Data 1.1 access calls to feed an
> variable containing XML to a SQL Server 2005 stored procedure?
>
> What data type and length should be named on the System.Data 1.1 type?
>
> OUT-BOUND
>
> If returning a table:
> Which data type should be used to return the XML datatype in the
> select?
>
> On the ADO.NET side, what should we cast the type to? How do we
> access it?
>
> If returning a -out or in-out parameter:
> Which data type should be used to return the XML datatype
>
> On the ADO.NET side, what should we cast the type to? How do we
> access it?
>
>
> Bonus question:
>
> Not only do we worry about XML datatype, we wonder about varchar(max)
> and nvarchar(max).
>
> We are worried we might do this wrong, so we are looking forward to your
> expertise and assistance in this situation. Thank you for any help you
> can render!! :-)
>
> Best regards,
> -- Li-fan
|