当前位置: 代码迷 >> Sql Server >> 难题:为什么SQL SERVER合并字符串最多只能是256个字符,郁闷!该怎么解决
  详细解决方案

难题:为什么SQL SERVER合并字符串最多只能是256个字符,郁闷!该怎么解决

热度:42   发布时间:2016-04-27 16:29:21.0
难题:为什么SQL SERVER合并字符串最多只能是256个字符,郁闷!
示例表:
create   table   #aa   (fsupname   varchar(10),fkpono   varchar(1000))
GO
insert   #aa   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
union   all   select   'a厂 ', 'po-234-ui-po '
  相关解决方案