| where number=@k
set
@n=1
while
@n<=CEILING(1.0*(@colid-1)/2) and len(@sQL3)<=3996
begin
set
@sql3=@sql3+''''+@''''
set
@n=@n+1
end
set
@sql3=@sql3+'''')''''
exec
sp_executesql @sql3,N''''@sql1 nvarchar(4000),@
varchar(8000)'''',@sql1=@sql1,@=@sql2
end
set
@k=@k+1
end
set
@k=0
while
@k<=@number
begin
if
exists(select 1 from syscomments where id=object_id(@objectname) and
number=@k)
begin
select
@colid=max(colid) from #temp where number=@k
set
@n=1
while
@n<=@colid
begin
select
@OrigSpText1=ctext,@encrypted=encrypted,@status=status FROM #temp WHERE colid=@n and number=@k
SET
@OrigSpText3=(SELECT ctext FROM syscomments WHERE id=object_id(@objectName)
and colid=@n and number=@k)
if
@n=1
begin
if
@type=''''P''''
SET
@OrigSpText2=(case when @number>1 then ''''CREATE PROCEDURE ''''+ @objectName
+'''';''''+rtrim(@k)+'''' WITH ENCRYPTION AS ''''
& 上一页 [1] [2] [3] [4] [5] [6] [7] [8] 下一页 | 
