Hi,
Thank for your prompt reply.
So, it mean that I can't apply the db change to my SP alone.
BTW, any good way to avoid using cursor in SP ?
It really slowing my performance.
In addition, why is it that when I am using
dynamic SQL, some of the string will be truncated
DECLARE @execstr varchar(4000)
SET @execstr = 'DECLARE ....'+
'....'+
'.....'
SELECT @execstr
Some of the string will be display. Please advise and comment,
tks
----------------------------------------------------------------------
Hi Virusim,
Using or not a language element it is decided by human choice,
You can export a SP script to check if cursor is used.
The string is not truely to be truncated but is not display enough,which is decided by a option setting "Maximum Characters per column" of "Tools"->"options"->"Results" tab,in your SQL Analyzer.Steven