======================================创建加密存储过程===========================================================================
create procedure proc_name
with encryption
as Sql_statement
--注释:
-- proc_name :存储过程名字
-- with encryption :加密存储过程的关键字
-- Sql_statement: 过程中一个或多个SQL语句
--完整实例:
if exists (select name from sysobjects where name='tb_BookSellProc' and type='p')
drop procedure tb_Booksellproc
go
use db_sql2008
go
create procedure tb_BookSellProc
with encryption
as
select * from tb_BookSell
go
exec sp_helptext tb_BookSellProc
exec tb_BookSellProc
create procedure proc_name
with encryption
as Sql_statement
--注释:
-- proc_name :存储过程名字
-- with encryption :加密存储过程的关键字
-- Sql_statement: 过程中一个或多个SQL语句
--完整实例:
if exists (select name from sysobjects where name='tb_BookSellProc' and type='p')
drop procedure tb_Booksellproc
go
use db_sql2008
go
create procedure tb_BookSellProc
with encryption
as
select * from tb_BookSell
go
exec sp_helptext tb_BookSellProc
exec tb_BookSellProc