Sql Service 查询报错SQLServerException: 不支持“variant”数据类型

最新推荐文章于 2024-08-17 23:14:52 发布

乄星落

最新推荐文章于 2024-08-17 23:14:52 发布

阅读量3.6k

点赞数 3

文章标签： sql service

本文链接：https://blog.csdn.net/qq_37612755/article/details/88735286

版权

原sql：SELECT t.name AS name,b.value AS comments
FROM sys.objects t LEFT JOIN sys.extended_properties b ON b.major_id=t.object_id and b.minor_id=0 and b.class=1 AND b.name='MS_Description'
WHERE t.type='U'
<if test="name != null and name != ''">
   AND t.name = upper(#{name})
</if>
ORDER BY t.name

修改后：SELECT  cast(t.name as varchar(500))  AS name,cast(b.value as varchar(500))  AS comments
FROM sys.objects t LEFT JOIN sys.extended_properties b ON b.major_id=t.object_id and b.minor_id=0 and b.class=1 AND b.name='MS_Description'
WHERE t.type='U'
<if test="name != null and name != ''">
   AND t.name = upper(#{name})
</if>
ORDER BY t.name

原因: 是由于SqlServer的ＪＤＢＣ的缺陷, 需要强制转换.

PS：可能由于用惯了mysql，遇到这种恶心人的玩意我就想骂娘。