34,590
社区成员
发帖
与我相关
我的任务
分享
DECLARE @ TABLE(c TEXT)
INSERT @
SELECT NULL
UPDATE a SET c='你好'+ISNULL(CAST(c AS VARCHAR(8000)),'') FROM @ AS a
UPDATE a SET c=CASE WHEN c IS NULL THEN '你好' ELSE CAST(c AS VARCHAR(8000))+'你好' end FROM @ AS a
SELECT * FROM @