Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-31 : 09:41:06
|
mahesh writes "DECLARE @SQLStringGeneral Nvarchar(4000)
SELECT @SQLStringGeneral = N' . . . '
select datalength(@SQLstringGeneral) as strdatalength, len(@SQLstringGeneral) as strLen2
EXEC sp_executesql @SQLstringGeneral
strdatalength strLen2
------------- -----------
588 294
I have declared the above variable, stored a valid sql tring to it (appending a valid 'where' clause) and then tried executing it. I find that, no matter what I do, the @SQLStringGeneral always truncates to 294 characters, and errors out when it hits execute EXEC statement.
I thought that Nvarchar could handle more characters than I am currently try to store.
I am using SQL Server 7.
thanks in advance for your help
mahesh" |
|
|
|
|
|
maximum storage NVARCHAR