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:
you using sql server syntax parameters in query, have expected this:
select id, username, password, formalname tblusers (username = [username]) , (password = [password])
Comments
Post a Comment