ALTER Proc [dbo].[Login_Valid_User]
@username varchar(50) = 'mayurgnu',
@passowd varchar(50) = 'mayurgnu',
@out int = 0 out
as
begin
if exists(
select 1 from MST_Employee where UserName = @username and Password = @passowd)
begin
set @out = 1
print @out
end
else
begin
set @out = 0
print @out
end
end
