22,209
社区成员
发帖
与我相关
我的任务
分享
select ID,content=cast(content as varchar(8000)) from tb
group by ID, cast(content as varchar(8000))
select
ID,cast(content as nvarchar(max))
from
[table]
group by
ID, cast(content as nvarchar(max))
--2005 以上尝试
select ID,cast(content as nvarchar(max) ) as content
from table
group by ID, cast(content as nvarchar(max) )
select
ID,content
from
[table]
group by
ID, cast(content as nvarchar(max))
select ID,content
from table
group by ID, cast(content as nvarchar(4000) )
--试试
select ID,cast(content as varchar(8000)) from table
group by ID, cast(content as varchar(8000))
--try
select ID,content from [table] group by ID, cast(content as nvarchar(max))