加密測試的存儲過程

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