DECLARE @str VARCHAR(max)
SET @str = (SELECT cast( '['+ strDate + '],'AS NVARCHAR(max)) FROM (SELECT distinct top 30 strDate FROM PlanTempTable ORDER BY strDate ) a FOR XML PATH(''))
SELECT left(@str,len(@str)-1)
- 结果如下
DECLARE @str VARCHAR(max)
SET @str = (SELECT cast( '['+ strDate + '],'AS NVARCHAR(max)) FROM (SELECT distinct top 30 strDate FROM PlanTempTable ORDER BY strDate ) a FOR XML PATH(''))
SELECT left(@str,len(@str)-1)