随笔分类 -  SQL基础

SQL
MS SQL While循环代替游标
摘要：--create temp1 tablecreate table #Grade(ID int identity(1,2),Name varchar(20),SubjectName varchar(20),Grade int)--insert datainsert into #Grade(Name,SubjectName,Grade) values('jimmy','Math',100)insert into #Grade(Name,SubjectName,Grade) values('jimmy','Chinese',110)in 阅读全文
posted @ 2014-03-07 17:36 TJM 阅读(220) 评论(0) 推荐(0)
MS SQL 行列转换
摘要：--create temp tablecreate table #Grade(Name varchar(20),SubjectName varchar(20),Grade int)--insert datainsert into #Grade(Name,SubjectName,Grade) values('jimmy','Math',100)insert into #Grade(Name,SubjectName,Grade) values('jimmy','Chinese',110)insert into #Grade(Name, 阅读全文
posted @ 2014-03-07 15:12 TJM 阅读(198) 评论(0) 推荐(0)