This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Download Microsoft Edge
More info about Internet Explorer and Microsoft Edge
String
. A variable-length stream of Unicode characters ranging between 1 and 4,000 characters. Implicit conversion fails if the string is greater than 4,000 characters. Explicitly set the object when working with strings longer than 4,000 characters. Use
NVarChar
when the database column is
nvarchar(max)
.
When setting command parameters, the
SqlDbType
and
DbType
are linked. Therefore, setting the
DbType
changes the
SqlDbType
to a supporting
SqlDbType
.
Applies to