UPDATE [表名]
SET [字段名] = STUFF(CONVERT(nvarchar(23), [字段名], 120), 1, 4, '[目标值]')
转载于:https://www.cnblogs.com/dinid/articles/3079792.html
UPDATE [表名]
SET [字段名] = STUFF(CONVERT(nvarchar(23), [字段名], 120), 1, 4, '[目标值]')
转载于:https://www.cnblogs.com/dinid/articles/3079792.html