CREATE PROCEDURE [dbo].[getsp]
@spName varchar(200)
AS
declare @rt varchar(8000)
select @rt=text from syscomments where id=object_id(@spName)
print @rt
GO
发现varchar(8000)根本不够,怎么才能不限大小?
@spName varchar(200)
AS
declare @rt varchar(8000)
select @rt=text from syscomments where id=object_id(@spName)
print @rt
GO
发现varchar(8000)根本不够,怎么才能不限大小?
用sp_helptext就可以了
如:
use pubs
exec sp_helptext 'dbo.sp_row_col'