SELECT * FROM OPENQUERY(INSQL, 'UPDATE History SET Value = 6000, QualityDetail =192
WHERE TagName = "电子皮带秤_A214.PV"
AND DateTime > "2021-01-03 09:42:29"
AND DateTime < "2021-01-03 09:44:29" ')
这段代码会把时间段内的数据都改成一个值，但是我想让这个值是浮动数据小数点后面三位小数于是修改代码
SELECT * FROM OPENQUERY(INSQL, 'UPDATE History SET Value =(convert(varchar(50),5000+ABS(CHECKSUM(NEWID()))%7+1) + "." + convert(varchar(50),ABS(CHECKSUM(NEWID()))%7+1)+ convert(varchar(50),ABS(CHECKSUM(NEWID()))%7+1)+ convert(varchar(50),ABS(CHECKSUM(NEWID()))%7+1)), QualityDetail =192
WHERE TagName = "电子皮带秤_A214.PV"
AND DateTime > "2021-01-03 09:42:29"
AND DateTime < "2021-01-03 09:44:29" ')
但是数据库报错
链接服务器“insql”的ole db 访问接口“insql”返回了消息“incorrect syntax near ‘（’ ”
我确定不是中英文字符的问题，在线求解答
