kadir

kadir

  • NA
  • 13
  • 0

STORED PROCEDURE ERROR

Jan 13 2011 9:40 AM


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
execute.pngdegergir.pngsonuc.png
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 belowtable.png

Answers (2)