摘要:
一丶行专列案例【借鉴】 1.建立表格 IF OBJECT_ID('tb') IS NOT NULL DROP TABLE tb go CREATE TABLE tb(姓名 VARCHAR(10),课程 VARCHAR(10),分数 INT) insert into tb VALUES ('张三',' 阅读全文
摘要:
SELECT id,Name FROM TeachSite GROUP BY id select top 1000 1 as [type],SchoolRollID,ChargeableAmount into #temp from ChargeRecord where bflag=1 select * from #temp select 2 as [type], Sch... 阅读全文