sqlserver 转 access,sql语句的修改
wfliu 2006-03-17 12:14:33 数据库由sqlserver转access后,下面sql语句应怎样修改 ?谢谢
SELECT spda.spid,
spda.spname,
spda.state,
spda.xfh,
spda.fjlx,
("zt" + state + ".jpg" )
FROM spda
ORDER BY spda.fjlx DESC,
spda.spid ASC
以上语句在sqlserver正常运行,到access后报错:
Select error:SQLSATAE = 37000
[Microsoft][ODBC Microsoft Access Driver]无效的括号名称"[.jpg]"