USE [BM]
GO
/****** Object: UserDefinedFunction [dbo].[ZfunWeek] Script Date: 2015-12-19 15:30:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER function [dbo].[ZfunWeek](@SDate CHAR(8),@EDate CHAR(8),@week int) returns
int
--计算周期
as
begin
while (@EDate>=@SDate)
begin
set @SDate=CONVERT(char(8),dateadd(dd,7,@SDate),112);
set @week=@week+1
set @weektemp= @week
end
return @weektemp
--select @weektemp
end
GO
/****** Object: UserDefinedFunction [dbo].[ZfunWeek] Script Date: 2015-12-19 15:30:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER function [dbo].[ZfunWeek](@SDate CHAR(8),@EDate CHAR(8),@week int) returns
int
--计算周期
as
begin
declare @weektemp int;-- declare @SDate char(8),@EDate char(8), @week int
while (@EDate>=@SDate)
begin
set @SDate=CONVERT(char(8),dateadd(dd,7,@SDate),112);
set @week=@week+1
set @weektemp= @week
end
return @weektemp
--select @weektemp
end