代码如下:–create database dbTemp use dbTemp create table test ( Pid int identity(1,1) not null primary key, Years datetime, IsFirstSixMonths int default(0), –0表示上半年1表示下半年– TotalCome int ) insert test select ‘2007-1-1’,0,50 union select ‘2007-3-1’,0,60 un
