declare @uid varchar(20) declare @pwd varchar(20) set @uid = 'IRSADMIN' set @pwd = '1' select * from usertable where uid = @uid and pwd =...@pwd
try the above one ll work and not as select * from usertable where uid = '@uid' and pwd ='@pwd'
declare @uid varchar(20) declare @pwd varchar(20) set @uid = 'IRSADMIN' set @pwd = '1' select * from usertable where uid = @uid and pwd =...@pwd
try the above one ll work and not as select * from usertable where uid = '@uid' and pwd ='@pwd'