如前所述，最好将列的数据类型设置为nvarchar（max），但如果无法做到，则可以使用cast或convert进行以下操作：
-- create a test table create table test ( a text) -- insert test valueinsert into test (a) values ('this is a text')-- the following does not work !!!update test set a = a + ' and a new text added'-- but this way it works: update test set a = cast ( a as nvarchar(max)) + cast (' and a new text added' as nvarchar(max) )-- test resultselect * from test-- column a contains:this is a text and a new text added希望能有所帮助
