===============================================修改存储过程========================================================
--判断存储过程是否存在
if exists(select name from sysobjects where name='tn_gukeproc'and type='p')
drop procedure tn_gukeproc
go
--创建存储过程
create procedure tn_gukeproc
as
select * from tb_顾客表 where 所在城市='吉林省吉林市'
go
exec tn_gukeproc
alter procedure tn_gukeproc
with encryption
as
select * from tb_顾客表
go
exec tn_gukeproc
--判断存储过程是否存在
if exists(select name from sysobjects where name='tn_gukeproc'and type='p')
drop procedure tn_gukeproc
go
--创建存储过程
create procedure tn_gukeproc
as
select * from tb_顾客表 where 所在城市='吉林省吉林市'
go
exec tn_gukeproc
alter procedure tn_gukeproc
with encryption
as
select * from tb_顾客表
go
exec tn_gukeproc