参看该帖第3条。不带分隔符的话:DECLARE @Datebases varchar(max) SET @Datebases = ( SELECT name AS [text()] FROM sys.databases ORDER BY name FOR XML PATH('')) --或者 SET @Datebases = ( SELECT ''+name FROM sys.databases ORDER BY name FOR XML PATH(''))
declare @sql varchar(8000) select @sql=isnull(@sql+'','')+name from classinfo select @sql
SET @Datebases = (
SELECT name AS [text()]
FROM sys.databases
ORDER BY name
FOR XML PATH(''))
--或者
SET @Datebases = (
SELECT ''+name
FROM sys.databases
ORDER BY name
FOR XML PATH(''))
select @sql=isnull(@sql+'','')+name from classinfo
select @sql