我用top出错 Syntax error or access violation: You have an error in your SQL syntax near '8 password from tb_user where username like '%d%' order by username' at line 1 top用在MSSQL中,有人说
csrcom(泥鳅) 的回答正确。
用这个strSQL = "select limit 1,8 password from tb_user where username like '%d%' order by username"; 结果:javax.servlet.ServletException: Syntax error or access violation: You have an error in your SQL syntax near 'limit 1,8 password from tb_user where username like '%d%' order by username' at line 1
改成了:strSQL = "select password from tb_user where username like '%d%' order by username limit 0,8 "; 出错为:javax.servlet.ServletException: Column Index out of range ( 2 > 1).
Syntax error or access violation: You have an error in your SQL syntax near '8 password from tb_user where username like '%d%' order by username' at line 1
top用在MSSQL中,有人说
结果:javax.servlet.ServletException: Syntax error or access violation: You have an error in your SQL syntax near 'limit 1,8 password from tb_user where username like '%d%' order by username' at line 1
2. offset=0 表示第一条
出错为:javax.servlet.ServletException: Column Index out of range ( 2 > 1).
up