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