SQL技巧(多行合并一列)

DECLARE @NAMES VARCHAR(1000)
SELECT @NAMES = ISNULL(@NAMES+',','')+ColumnCode FROM  DB_TableColumns 
WHERE TableCode='faFixedAssets' ORDER BY UID
select @NAMES

posted on 2012-01-05 08:16  笑看风云淡  阅读(238)  评论(0)  编辑  收藏  举报

导航