2020-02-16 标签:mssql,case,group,用法,实现,代码,如下,create,database,dbtemp,use,table,test,pid,int,identity,n,ot,ull

实现代码如下：--create database dbTemp use dbTemp create table test ( Pid int identity(1,1) not null primary key, Years datetime, IsFirstSixMonths int defaul