【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-316.sql,希望本篇文章对您学习有所帮助。
if exists(select name from sysobjects where name='pro_person15' and type='p')
drop proc pro_per15
go
use db_SQL
go
create procedure pro_Ren15
as
select * from tb_Ren15
where 家庭住址='吉林省'
go
exec sp_rename 'pro_Ren15','pro_pRen15'
go