When a clr has the input type of SqlString it causes nvarchar(4000) to be the parameter type of the

D

DR

When a clr has the input type of SqlString it causes nvarchar(4000) to be
the parameter type of the function in sql server. how to modify my CLR
function to use nvarchar(max) ?
 
N

Nicholas Paldino [.NET/C# MVP]

DR,

When you create the CLR stored procedure, you have to issue a CREATE
PROCEDURE command. In that command, you specify what the parameters should
be. A SqlString parameter can accomidate any size string that SQL Server
can accomidate.
 

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

nvarchar(max) sql data type equivalen in c# 2
Attribute on return value, how ?? 2
Fastest way to move XML document into and back out of CLR function 1
case sensitive database and sql command parameters 2
Re: Parameter size for NVARCHAR(MAX) data type? 0
Data Type nvarchar or varchar 13
Getting SQL data types using C# 5
ODBC IMPORT VS LINK TABLE 3

Top