使用JDBC过程中查询MSSQL库中的字段名和注释拼接的SQL运行出错？

Question

 SELECT A.name AS table_name,B.name AS column_name,C.value AS column_description FROM sys.tables A INNER JOIN sys.columns B ON B.object_id = A.object_id LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id AND C.minor_id = B.column_id WHERE A.name = '+paramDaoData.getTABLE_NAME()+"

com.microsoft.sqlserver.jdbc.SQLServerException: 不支持“variant数据类型
这个怎么该请求大神的指点？

Answer 1

 A.name = '+paramDaoData.getTABLE_NAME()+"
 这一块代码出错了，两边应该改成
  A.name = '"+paramDaoData.getTABLE_NAME()+"'"