行列转换
摘要:
1、行转换成列:if object_id('tablename')is not null drop table tablenameselect 'x1'as [name], '2006-01-01' as [date], 'aaaa' as nrinto tablenameunion select 'x1', '2006-01-02', 'bbbb'union select 'x3', '2006... 阅读全文
posted @ 2006-11-06 14:26 xiaoc.li 阅读(154) 评论(0) 推荐(0)