enutter的专栏

Declare @BeginYear As SmallIntDeclare @EndYear As SmallInt Declare @BeginMonth As TinyInt Declare @EndMonth As TinyIntSet @BeginYear = 2009Set @EndYear = 2010 Set @BeginMonth = 10Set @EndMonth

create function [dbo].[GetRangeDays] (@dtRange1From DATE,      @dtRange1To DATE,      @dtRange2From DATE,      @dtRange2To DATE)RETURNS int    AS    BEGIN        IF NOT ( @dtRange2From

-- 0 = 19000101-- 得到某月的第一天SELECT DATEADD(m, DATEDIFF(m, 0, GETDATE()), 0)-- 去除DateTime的时间部分SELECT DATEADD(d, DATEDIFF(d, 0, GETDATE()), 0)