adExecuteStream and navarchar(4000) ?
Posted on 2002-03-19
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 ?