sql server 创建加密存储过程

======================================创建加密存储过程===========================================================================
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