请问在SQLserver中字段名为数字，应该在语句中怎么查询？

Question

    SQL="select b.DEV_NAME,b.PROJECTS,a.* from(select * from PAR_GJYS_DATA1)a full join (select * from DEV_BASIC_INFO)b "
    +"on a.INID=b.INID where a.INID="+cxid+" and b.PROJECTS="+xmmc+"and  CONVERT(005002001,CHAR); ="+"'"+cjmc+"'";

 

com.microsoft.sqlserver.jdbc.SQLServerException: “005002001”附近有语法错误。

Answer 1

select * from test where [12354]='IBM'