Loading

STORED PROCEDURE ERROR

kadir

15y10.7kSQL

I have a stored procedure at below:
ALTER proc [dbo].[kullaniciGiris]
(
@kullaniciAdi nvarchar(50),
@kullaniciSifre nvarchar(50)
)
as
select kullaniciId,yoneticiMi,kullanicitipId from tblKullanicilar
where kullaniciAdi=@kullaniciAdi and kullaniciSifre=HASHBYTES('SHA1',@kullaniciSifre)
I execute this procedure

Result:I don't have a data
query don't executed true
why?
I want to execute this procedure and I see data in result

this procedure work on table below

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
Input Datatype is nvarchar and column datatype is varbinary, so you need a conversion to retrive te data.

refer, might helps..

http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?ThreadID=50983
0
Madhu K15y ago
HASHBYTES('SHA1','abc123') value will be 0x689307D2FC53AF0FB941BC1BB42737CE4F3EF540

you procedure selects for records with kekiz and 0x689307D2FC53AF0FB941BC1BB42737CE4F3EF540 so you dont get any records to display unless the
converted value (0x689307D2FC53AF0FB941BC1BB42737CE4F3EF540 ) is present in your table.
0