日期:2014-05-17 浏览次数:20512 次
DECLARE @jbr int
SELECT 1 AS id ,'10050001' AS workcode,'b59c67bf196a4758191e42f76670ceba' AS password INTO #HrmResource UNION
SELECT 2,'10050002','934b535800b1cba8f96a5d72f72f1611' UNION
SELECT 3,'10050003','2be9bd7a3434f7038ca27d1918de58bd'
SELECT @jbr=id FROM #HrmResource WHERE workcode=@workcode AND password=right(master.dbo.fn_varbintohexsubstring(1,HashBytes('MD5',@password),1,0),32)
SELECT @jbr as jbr
DECLARE @workcode varchar(50)
DECLARE @password varchar(50)
SELECT @workcode='10050001',@password='1111'
DECLARE @jbr int
SELECT 1 AS id ,'10050001' AS workcode,'b59c67bf196a4758191e42f76670ceba' AS password INTO #HrmResource UNION
SELECT 2,'10050002','934b535800b1cba8f96a5d72f72f1611' UNION
SELECT 3,'10050003','2be9bd7a3434f7038ca27d1918de58bd'
SELECT @jbr=id FROM #HrmResource WHERE workcode=@workcode AND password=right(master.dbo.fn_varbintohexsubstring(1,HashBytes('MD5',@password),1,0),32)
SELECT @jbr as jbr