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  笑看风云淡  阅读(246)  评论(0)    收藏  举报

导航