tag:blogger.com,1999:blog-3720495305544590742.post6640179324206255817..comments2023-05-01T04:08:40.086-07:00Comments on Mi Rincon Tecnologico: Encriptar clave en SQL Server 2005adminhttp://www.blogger.com/profile/13543933220990885985noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3720495305544590742.post-8039803301287824442011-12-23T11:12:59.737-08:002011-12-23T11:12:59.737-08:00disculpa pero esto no me sale ni por descreto.. se...disculpa pero esto no me sale ni por descreto.. sera que estoy fallando en algo....... saludo<br /><br />GO<br />create procedure usuario2<br />(<br />@Email nvarchar(50),<br />@pwd varchar(256)<br />--@error int = 0 output<br />)<br />As<br />BEGIN <br />SELECT Email,Passwords FROM Registro WHERE Email=@Email AND pwdcompare(@pwd,Passwords,0)=1 <br /><br />END<br />GO<br /><br />y asi paso los datos<br />Convert(varbinary(256),pwdencrypt('@Passwords'))Anonymoushttps://www.blogger.com/profile/07058881088179604545noreply@blogger.com