-- 根據存儲過程名取存儲過程內容
-- 調試 GetContentByProcedureName '[dbo].[CPP_CountOfTrdeByUserID]'
alter procedure GetContentByProcedureName
( @ProcedureName nvarchar ( 500 ))
as
if exists ( select * from dbo.syscomments where id = object_id (N'' + @ProcedureName+ '' ))
select c. text , c.encrypted, c. number , xtype = convert ( nchar ( 2 ), o.xtype),
datalength (c. text ), convert ( varbinary ( 8000 ), c. text ), 0 from dbo.syscomments c, dbo.sysobjects o
where o.id = c.id and c.id = object_id (N'' + @ProcedureName + '' )
order by c. number , c.colid option (robust plan )
存儲過程總top+變量參數
Alter proc getWorkPlan2
(
@intCounter int
, @lngUserID int
)
as
set rowcount @intCounter
select lngWorkID,strWorkName,strExecHumanName,strBeginDate
from worklist where lngExecHumanID = @lngUserID
order by lngWorkID desc
