create procedure Chk_UnamePWD @UName varchar,@PWD varchar as begin select count(*) from tblCustomerVendorInfo where CVUserName=@UName and CVPassword=@PWD; end exec Chk_UnamePWD 'BBB','BBB'
Declare @Result int if exists(select * from product where name = 'product1') begin set @Result=1 select @result end else begin set @Result=0 select @Result end
select count(*) from tblCustomerVendorInfo where CVUserName='BBB' and CVPassword='BBB';
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)