update tb1 set Content=a.Content+ CHAR(13) + CHAR(10) + b.Content
CCRM_Service a inner join tb2 b on a.ID=b.ID 其中Content 是text型的,怎么处理呢?
CCRM_Service a inner join tb2 b on a.ID=b.ID 其中Content 是text型的,怎么处理呢?
调试欢乐多
cast([text型] as varchar)
update tb1 set Content=convert(varchar(max),a.Content)+ CHAR(13) + CHAR(10) + convert(varchar(max),b.Content)
CCRM_Service a inner join tb2 b on a.ID=b.ID
CCRM_Service a inner join tb2 b on a.ID=b.ID
cast(text字段 as varchar(max))在sql2005,好像varchar(max)好像最多能存储好几个G