Cevap: Hesap Güvenliği (Password MD5 Şifreleme)
DECLARE @strAccountID varchar(50),@strPasswd varchar(50),@strPasswdBackup varbinary(255)
DECLARE TB_USER CURSOR FOR
SELECT strAccountID,strPasswd,strPasswdBackup FROM TB_USER
OPEN TB_USER
FETCH NEXT FROM TB_USER INTO @strAccountID,@strPasswd,@strPasswdBackup
WHILE (@@FETCH_STATUS = 0)
BEGIN
UPDATE TB_USER SET strPasswdBackup = dbo.CreateHash(@strPasswd) WHERE strAccountID = @strAccountID
FETCH NEXT FROM TB_USER INTO @strAccountID,@strPasswd,@strPasswdBackup
END
CLOSE TB_USER
DEALLOCATE TB_USER
____________________________________________________________
Server: Msg 245, Level 16, State 1, Line 9
Syntax error converting the varchar value 'karabulut' to a column of data type int.
AKUMA YARDIM ET LUTFEN DB YE GIRDILER BÖLE BIR HATA VERIYOR HESAPLARI SIFRELICEKKEN