34,837
社区成员




UPDATETEXT tb
set url='www.baidu.com'+isnull(url,'')
DECLARE @ptrval binary(16)
SELECT @ptrval = TEXTPTR(url) FROM tb
UPDATETEXT tb.url @ptrval 0 0 'www.baidu.com';
update music
set url='www.baidu.com'+isnull(url,'')
update music
set url='www.baidu.com'+isnull(url,'')
select 'www.baidu.com'+isnull(url,'') from music
update music
set url='www.baidu.com'+isnull(url,'')