Re: System.Data 1.1 / ADO.NET 1.1 and large datatypes introduced in SQL Server 2005

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
.

Relevant Pages

  • System.Data 1.1 / ADO.NET 1.1 and large datatypes introduced in SQL Server 2005
    ... Unfortunately not all of the asp.net projects could be upgraded to 2.0 and we are a little confused about how to access the large data types introduced in SQL Server 2005. ... We have some questions about feeding SQL Server xml datatypes and retrieving xml datatypes: ... Which data type should be used to return the XML datatype in the select? ... what should we cast the type to? ...
    (microsoft.public.sqlserver.xml)
  • Re: Access 97 to SQL
    ... The timestamp is a data type, ... the timestamp field does not need to be part of the SELECT ... > converted the Access tables to a SQL Server 2000 database and linked the ... > the way I set up Autonumbering in SQL? ...
    (microsoft.public.access.externaldata)
  • Re: Data Types
    ... > moved to SQL Server and I don't know the best newsgroups yet. ... > Does a Unique Identifier data type take up less storage space than a 32 ... A uniqueidentifier uses 16 bytes. ... but I'm looking at the data types and think that the TimeStamp ...
    (microsoft.public.sqlserver.programming)
  • Re: Update string too long?
    ... search through the newsgroups, as wells as google.com for the web. ... Pro SQL Server 2000 Database Design - ... Beginner posts are the most helpful and it is ... what is the data type and length for the ...
    (microsoft.public.sqlserver.programming)
  • Re: How Can I Write a SQL Server Function that Returns a Memo Data Type in Access?
    ... When I use the function in a view and link to the view through ODBC, ... Text data type. ... LONGTEXT, LONGCHAR, MEMO, and NOTE aren't recognized by SQL Server. ...
    (comp.databases.ms-access)
Loading