我正在處理 SQL 中的匯入腳本，除了 STRING_AGG 部分之外，該腳本目前作業正常。我需要它采用特定格式，但我似乎無法找到完成此操作的方法。
目前它正在輸出：00000000-0000-0000-0000-000000000000, 00000000-0000-0000-0000-000000000000。
我需要的是： ["00000000-0000-0000-0000-000000000000","00000000-0000-0000-0000-000000000000"]
我用 CONCAT 嘗試了一些東西，但根本沒有得到任何輸出，這怎么辦？
WITH CTE_EnrichmentProperty (EntityId, EnrichmentIndex, IbProductKey) AS (
SELECT DISTINCT EntityId
, EnrichmentIndex
, IbProductKey
FROM dbo.ArticleEnrichmentImportItem
WHERE ArticleEnrichmentImportItem.ArticleEnrichmentImportId = @ImportId
AND ArticleEnrichmentImportItem.EnrichmentType = 'EnrichmentPropertySelection'
AND ArticleEnrichmentImportItem.State IN (1, 2, 3)
)
INSERT INTO Attribute (Id, Type, EnrichmentProperty_EnrichmentPropertyId, EnrichmentProperty_Value)
SELECT ArticleEnrichmentImportItem.Id,
'enrichment',
CTE_EnrichmentProperty.EntityId,
(SELECT STRING_AGG(CAST(EntityId AS varchar(38)), ',') FROM dbo.ArticleEnrichmentImportItem A
WHERE A.ArticleEnrichmentImportId = @ImportId
AND A.EnrichmentType = 'EnrichmentPropertySelectionValue'
AND A.EnrichmentIndex = ArticleEnrichmentImportItem.EnrichmentIndex
And A.IbProductKey = ArticleEnrichmentImportItem.IbProductKey
)
FROM dbo.ArticleEnrichmentImportItem
JOIN CTE_EnrichmentProperty ON CTE_EnrichmentProperty.EnrichmentIndex = ArticleEnrichmentImportItem.EnrichmentIndex
WHERE ArticleEnrichmentImportItem.ArticleEnrichmentImportId = @ImportId
AND ArticleEnrichmentImportItem.EnrichmentType = 'EnrichmentPropertySelectionValue'
AND ArticleEnrichmentImportItem.IbProductKey = CTE_EnrichmentProperty.IbProductKey;
uj5u.com熱心網友回復：
...
SELECT CONCAT( '["',
STRING_AGG(CAST(EntityId AS varchar(38)), '","'),
'"]'
),
...
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/529795.html
標籤：sqlsql服务器