Ping Lee

摘要：CREATE TABLE [dbo].[tb]([id] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,[name] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,[age] [int] NULL)INSERT INTO [tb] ([id],[name],[age]) VALUES (1,a,11)INSERT INTO [tb] ([id],[name],[age]) VALUES (2,b,22)INSERT INTO [tb] ([id],[name],[age]) VALUES (3,c,33 阅读全文

摘要：select getdate() --当前日期select day(getdate()) --目前第几天select getdate()-day(getdate()) --上个月最后一天select dateadd(mm,1,getdate())-day(getdate()) --加上一个月select day(dateadd(mm,1,getdate())-day(getdate())) --获得当月天数 阅读全文