UPDATE [UserAttList]
SET AttValue = cast((cast(AttValue as int)+100) as varchar)
WHERE (UserName = 'sjx') AND (AttID = 'A002')
sql语句中 int varchar互相转换
最新推荐文章于 2024-01-15 11:17:18 发布
UPDATE [UserAttList]
SET AttValue = cast((cast(AttValue as int)+100) as varchar)
WHERE (UserName = 'sjx') AND (AttID = 'A002')