update TXET字段 并在字段后面增加字符‘aa’的如何写

[jxwa_wzw]

表tablea有一个字段 dd 类型text
update tablea set dd=dd+'aa' 执行会失败？请问应该如何写？

[青锋-SS]

update tablea
set dd=cast(dd as varchar)+'aa' as text)

[青锋-SS]

update tablea
set dd=cast(cast(dd as varchar)+'aa' as text)

[中国风]

用游標執行UPDATETEXT命令更新
字符少於8000時，可用
cast(col as varchar(8000))+'aa'

[linux_ch]

[Quote=引用 2 楼 sdhylj 的回复:]
SQL codeupdate tablea
set dd=cast(cast(dd as varchar)+'aa' as text)
[/Quote]

[zoujp_xyz]

结合使用：可以看看联机丛书的说明
textvalid()
textptr()
updatetext()

[中国风]

declare cur cursor for 
select textptr(Col) from T
declare @p binary(16)
open cur
fetch next from cur into @p
while @@fetch_status=0
begin
	updatetext T.Col @p null null N'aa'
	fetch next from cur into @p
end
close cur
deallocate cur