可以直接用sql调阅数据库中的脚本,举例如下 sql2000版本: DECLARE @spName NVARCHAR(100); SET @spName='存储过程名称'; DECLARE @spSql NVARCHAR(4000);SELECT @spSql = CONVERT(NVARCHAR(4000),ctext) FROM syscomments WHERE (id = (SELECT id FROM sysobjects WHERE name=@spName));PRINT ISNULL(@spSql,'is null');sql2012版本: DECLARE @spName NVARCHAR(100)='存储过程名称'; DECLARE @spCode VARCHAR(MAX)= ISNULL((SELECT definition FROM sys.all_sql_modules where object_id=( SELECT object_id FROM sys.Procedures WHERE name=@spName)),'is null'); PRINT @spCode;其它sql版本或更多详情可以查询MSDN,搜索关键字从代码示例中摘取 以下是MSDN t-SQL的主页: http://msdn.microsoft.com/zh-cn/library/bb510741(v=sql.120).aspx
sql2000版本:
DECLARE @spName NVARCHAR(100);
SET @spName='存储过程名称';
DECLARE @spSql NVARCHAR(4000);SELECT @spSql = CONVERT(NVARCHAR(4000),ctext)
FROM syscomments
WHERE (id = (SELECT id FROM sysobjects WHERE name=@spName));PRINT ISNULL(@spSql,'is null');sql2012版本:
DECLARE @spName NVARCHAR(100)='存储过程名称';
DECLARE @spCode VARCHAR(MAX)=
ISNULL((SELECT definition
FROM sys.all_sql_modules where object_id=(
SELECT object_id FROM sys.Procedures
WHERE name=@spName)),'is null');
PRINT @spCode;其它sql版本或更多详情可以查询MSDN,搜索关键字从代码示例中摘取
以下是MSDN t-SQL的主页:
http://msdn.microsoft.com/zh-cn/library/bb510741(v=sql.120).aspx