【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-315.sql的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
if exists(select name from sysobjects where name='pro_per15'and type='p')
drop proc pro_per15
go
use db_SQL
go
CREATE PROCEDURE pro_per15
AS
SELECT *
FROM tb_person15 where 家庭住址='黑龙江省'
GO
alter procedure pro_per15
with encryption
as
select * from tb_person15 where 家庭住址='吉林省'
order by 人员编号 desc
go
exec pro_per15
go