存储过程用法

1 create procedure proc_test01
2 as
3 begin
4 select * from  myrptdetail
5 end

exec   proc_test01

1 create procedure proc_test02
2 @param nvarchar(50)
3 as
4 begin
5 select * from  myrptdetail  where myrptdetailid=@param
6 end

exec  proc_test02 ‘66F58203-2C49-4B3B-B296-03D2A060172F‘

1 alter procedure proc_test01
2 as
3 begin
4 select ‘这是在修改存储过程‘ as ps, * from  myrptdetail
5 end

exec sp_helptext proc_test01