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

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -