1.如果你SQLServer的表名含有空格...
那么在你写SQL语句的时候,一定要把带有空格的表名用[]括号,括起来!
例如:select * from [Asset administrators] where name='China4'
2.含空格的双表同查语句
select * from [含空格的表名],表名 where [含空格的表名].列名='?' and 表名.列名='?'
String sql="select * from [Asset administrators] ,Employee where [Asset administrators] .name='"+usename+"' and [Asset administrators] .password='"+obj+"' and Employee.Ename='"+usename+"' and Employee.Epwd='"+obj+"'";
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13683607/viewspace-255325/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13683607/viewspace-255325/