SQL技巧(多行合并一列)
摘要:
DECLARE @NAMES VARCHAR(1000)SELECT @NAMES = ISNULL(@NAMES+',','')+ColumnCode FROM DB_TableColumnsWHERE TableCode='faFixedAssets' ORDER BY UIDselect @NAMES 阅读全文
posted @ 2012-01-05 08:16 笑看风云淡 阅读(238) 评论(0) 推荐(0) 编辑