摘要:
1 select * from TbaleOne 2 unpivot(qty for years in ([2002],[2003],[2004])) as up 3 go 4 5 select * from TableTwo 6 unpivot(grate for subject in [kemu 阅读全文
摘要:
1 SELECT 2 columnTableName = case when a.colorder=1 then d.name else '' end, --表名 3 columnTableDes = case when a.colorder=1 then isnull(f.value,'') el 阅读全文