Solved

adExecuteStream and navarchar(4000) ?

Posted on 2002-03-19
3
346 Views
Last Modified: 2011-10-03
Can anyone explain this ?
In SQL Server 2000 books online there is an example under
topic XML called Sample Visual Basic Application  To Update Records Using OPENXML And ADO.

Now VB helps says using adExecuteStream allows you up to
about 2GB of data, as does the Visual Basic type String.

However, the example shows a stored procedure with a parameter of nvarchar(4000), which is used to pass in the XML .
The VB code for the example uses adExecuteStream. But
what happens if the XML is longer than nvarchar(4000) ?
Surely the example is flawed ?
0
Comment
Question by:josereyes
3 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 100 total points
ID: 6879765
The example is NOT flawed, as NVARCHAR has a max size of 4000. If you want to store more data, you need to use the TEXT datatype (without size, able to store up to 2GB of data).

CHeers
0
 

Expert Comment

by:CleanupPing
ID: 9280741
josereyes:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now