Access query convert to MSSQL query
-
I have a little bit of SQL code and I am having trouble bringing it over to MSSQL. I don't even know where to being I know that the SELECT, FROM , GROUP BY and HAVING will be in the MSSSQL query. However I know for a fact the 4th line will change into
@param1and@param2. If anyone would like to add some input into this would be nice. Access QuerySelect COUNT(') AS Result, Username AS UsernameInput, [Password]
FROM access
GROUP BY Username, [Password]
Having (COUNT(') = 1) AND (Username = ?) AND ([Password] = ?) -
I have a little bit of SQL code and I am having trouble bringing it over to MSSQL. I don't even know where to being I know that the SELECT, FROM , GROUP BY and HAVING will be in the MSSSQL query. However I know for a fact the 4th line will change into
@param1and@param2. If anyone would like to add some input into this would be nice. Access QuerySelect COUNT(') AS Result, Username AS UsernameInput, [Password]
FROM access
GROUP BY Username, [Password]
Having (COUNT(') = 1) AND (Username = ?) AND ([Password] = ?)Change the single quote ' to an asterisk * in the count functions. eg count(*)
Never underestimate the power of human stupidity RAH