摘要: 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& 阅读全文
posted @ 2013-07-13 23:25 Tom Fan 阅读(256) 评论(0) 推荐(0) 编辑
摘要: 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 阅读全文
posted @ 2013-07-13 22:52 Tom Fan 阅读(252) 评论(0) 推荐(0) 编辑