Question

sql server 2005 查询 当前数据库中的存储过程怎么sql 语句怎么写啊

Answer 1

创建存储过程如下，可以不带参数，也可带，还可带输出参数
create procedure pro_*(自命名)
[@test1 varchar[]=初始值]
[@test2 varchar[]=初始值]

as
select top(@test1) * from 表 where 列=@test2
go

调用输出存储过程，须向里面传递参数，
//declare @s varchar() 如有输出参数
exec 存储过程名 '参数一','参数二'

Answer 2

-- 查看函数和过程的状态
select object_name,status from user_objects where object_type='FUNCTION';
select object_name,status from user_objects where object_type='PROCEDURE';

-- 查看函数和过程的源代码
select text from all_source where owner=user and name=upper('&plsql_name');

Answer 3

存储过程 与 相应的创建存储过程的SQL语句
select
pro.name AS ProcedureName,
c.text AS CreateProcedureSQL
from
sys.procedures pro LEFT OUTER JOIN
dbo.syscomments c ON pro.object_id = c.id

函数 与 相应的创建函数的SQL语句
SELECT
o.name AS FunctionName,
c.text AS CreateFunctionSQL
FROM
dbo.sysobjects o LEFT OUTER JOIN
dbo.syscomments c ON o.id = c.id
WHERE
o.xtype IN ('IF', 'TF', 'FN')
AND (OBJECTPROPERTY(o.id, N'IsMSShipped') = 0)