Tom Fan

摘要： create table product (ID int identity(1,1) primary key,ProductName varchar(20),productType varchar(20)) insert product values('羊羊鞋','L') insert product values('羊羊鞋','XL') insert product values('羊羊鞋','XXL') insert product values('羊羊鞋','XXXL& 阅读全文

摘要： with tabs as ( select row_number() over (order by name) as rowNum , convert(varchar(10),dateadd(dd,number,convert(varchar(8),getdate(),120)+'01'),120) as dt from master..spt_values where type='P' and dateadd(dd,number,convert(varchar(8),getdate(),120)+'01')0 阅读全文