--建立测试环境 set nocount on createtable test(model varchar(20),date int ,qty int) insertinto test select'a','8','10' insertinto test select'a','10','50' insertinto test select'b','8
社区问的人太多了,保存一个备用--建立测试环境set nocount oncreate table test(model varchar(20),date int ,qty int)insert into test select a,8,10insert into test select a,10,50insert into test select b,8,