Hi sampath,
ALTER procedure chkloginSP(@ui varchar(50),@pass varchar(50),@no int out)
as
begin
select @no=COUNT(*) from loginc where userid=@ui and password=@pass
end
This is running pretty fair at my end. I use sql server 2005. Also, I can see the variable @no is declared correctly in the parameters. No problems with that. Maybe you're not selecting the whole stored procedure while executing it. Try it once again.