高手请进 存储过程中字符串长度问题
各位高手,我在SQL2K中的增加了一个存储过程,里面用到以下一些语句:
...
DECLARE @SQL nvarchar(2000)
...
set @SQL='Insert into tb_Tmp_StocksInOut_JewelCode(JewelCode,JewelName)
( SELECT distinct JewelCode,JewelName FROM vi_JewelStocksInOut_List
where ((OutStorage=''山即东墨'') or (InStorage=''山即东墨''))
and (TabDate>=''2009-7-1'' and TabDate<''2009-7-31'') order by JewelCode )'
print @SQL
...
但是奇怪的问题出现了,我在调试此存储过程中,发现赋过值的SQL,被截取了.如下:
'Insert into tb_Tmp_StocksInOut_JewelCode(JewelCode,JewelName)
( SELECT distinct JewelCode,JewelName FROM vi_JewelStocksInOut_List
where ((OutStorage=''山即东墨'') or (InStorage=''山即东墨''))
and (TabDate>=''2009-7-1'' and TabDate<''2009-7-31'') or'
请问大家这是什么问题?
我前面定义的长度为2000啊,长度应该够长吧