SQLÈÕÀú±íÊý¾ÝµÄ¼òµ¥Éú³É

ΪÁ˹«Ë¾¿¼ÇÚϵͳµÄÐèÒª
±àдµÄ¼¸¸ö¼òµ¥´æ´¢¹ý³Ì(¿ÉÒÔÊÖ¶¯ÔËÐÐ,Ò²¿ÉÒÔÉèÖÃÊÂÎñ×Ô¶¯ÔËÐÐ!¸Ð¾õ»¹ÐбȽÏͨÓÃ,д³öÀ´¹²ÏíÏÂ)
Calendar±í½á¹¹ºÜ¼òµ¥,2¸ö×Ö¶Î:
fdDate ÈÕÆÚ
fdType ¿¼ÇÚÀàÐÍ(¹¤×÷ÈÕN,ÖÜÄ©W,½Ú¼ÙÈÕH[ÐèÒª¸ù¾ÝÐèÒª×Ô¼ºÐÞ¸Ä])
--ÅжÏÒ»¶Îʱ¼ä·¶Î§ÄڵŤ×÷ÈÕ£¨N£©ºÍÖÜÄ©£¨W£©
Create     PROCEDURE [dbo].[NewMonthWeekDay_Calendar]
@sdate smalldatetime,
@edate smalldatetime
AS
declare @fdDate smalldatetime
declare @WeekDay varchar(20)
declare cr0 cursor for
 select fdDate from calendar where fddate>=@sdate and fddate<=@edate
open cr0
fetch next from cr0 into @fdDate
 while @@fetch_status=0
 begin
  if (datename(weekday,@fdDate)='ÐÇÆÚÒ»')
   update calendar set fdType='N' where fdDate=@fdDate
  if (datename(weekday,@fdDate)='ÐÇÆÚ¶þ')
   update calendar set fdType='N' where fdDate=@fdDate
  if (datename(weekday,@fdDate)='ÐÇÆÚÈý')
   update calendar set fdType='N' where fdDate=@fdDate
  if (datename(weekday,@fdDate)='ÐÇÆÚËÄ')
   update calendar set fdType='N' where fdDate=@fdDate
  if (datename(weekday,@fdDate)='ÐÇÆÚÎå')
   update calendar set fdType='N' where fdDate=@fdDate
  if (datename(weekday,@fdDate)='ÐÇÆÚÁù')
   update calendar set fdType='W' where fdDate=@fdDate
  if (datename(weekday,@fdDate)='ÐÇÆÚÈÕ')
   update calendar set fdType='W' where fdDate=@fdDate
  
  fetch next from cr0 into @fdDate
 end
close cr0
deallocate cr0 
--¸ù¾ÝÄêºÍÔÂ×Ô¶¯²åÈëCalendar±íÐÂÈÕÆÚÊý¾Ý
Create    PROCEDURE [dbo].[NewMonth_Calendar]
@Year int,
@Month int
AS
 Select TOP 50 ID = Identity(Int, 0, 1) Into #T from SysColumns
 insert into cas..calendar(fdDate)
 Select Convert(Varchar(10), DateAdd(dd, ID, Cast(Rtrim(@Year) + '-' + Rtrim(@Month) + '-' + '01' As DateTime)), 120) from #T
 W