1.select name from sysobjects where xtype='p'
2.sp_helptext 存储过程
3.ALTER PROC [ EDURE ] procedure_name [ ; number ]
[ { @parameter data_type }
[ VARYING ] [ = default ] [ OUTPUT ]
] [ ,...n ] [ WITH
{ RECOMPILE | ENCRYPTION
| RECOMPILE , ENCRYPTION
}
]
[ FOR REPLICATION ]
AS
sql_statement [ ...n ]
create proc proA
as
select 1
EXEC proA修改过程
alter proc proA
as
select 2
EXEC proA