Parameter size for NVARCHAR(MAX) data type?

  • Thread starter pedestrian via DotNetMonster.com
  • Start date
P

pedestrian via DotNetMonster.com

I have an ASP.NET 1.1 page to call a stored procedure in the SQL Server 2005.

If I use the NVARCHAR(MAX) data type in a SQL Server 2005 stored proc,
What should I use for parameter size for SqlParameter in Visual Basic.NET
2003 in order to pass in correct parameter?

Thanks...

--
Regards,
Pedestrian, Penang.

Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-ado-net/200710/1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re: Parameter size for NVARCHAR(MAX) data type? 0
Reverse the Day and Month position in DateTime structure? 5
Parameter Type/Size Property Values for VARCHAR(MAX) Stored Proc Parameter 2
varchar(max) - SqlParameter 2
Is it Posible Access VarBinary(MAX) From SqlDbType.Image 1
When a clr has the input type of SqlString it causes nvarchar(4000) to be the parameter type of the 1
Data Type nvarchar or varchar 13
SqlCommand Parameters with SqlDbType and VarChar(MAX) 1

Top