日期:2014-05-18  浏览次数:20583 次

难题:为什么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 &n