sql - Why do Select Statement returns a row though the parameter in Where Clause didn't match any records? -


i have query in microsoft access:

parameters username text, password text; //value entered username = 'a' //value entered password = 'a'  select id, username, password, formalname tblusers (username = @username) , (password = @password) 

i expecting not return row because there no such username 'a' , no such password 'a' did return row:

enter image description here

you using sql server syntax parameters in query, have expected this:

select id, username, password, formalname tblusers (username = [username]) , (password = [password]) 

Comments

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

javascript - jQuery date picker - Disable dates after the selection from the first date picker -