SQLSERVER对加密的存储过程、视图、触发器进行解密(推荐)

加密测试的存储过程

IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE TYPE='P' AND NAME='P_TEST')
DROP PROCEDURE P_TEST
Go
CREATE PROCEDURE P_TEST(@USERNAME VARCHAR(20),@MSG VARCHAR(20) OUTPUT)
WITH ENCRYPTioN
AS
BEGIN
  IF(SELECT COUNT(1) FROM Custs WHERE NAME=@USERNAME)>0
    SET @MSG='此用户名存在'
  ELSE
    SET @MSG='此用户名不存在'
END