摘要:
alter proc [work]asdeclare @i intset @i=1while @i=( select id from #restdate )set @i=@i+1drop table #restdateend 阅读全文
摘要:
DECLARE @DATE DATETIMESET @DATE=GETDATE()SELECTSUN=MAX(CASE WHEN DATEADD(DAY,NUMBER,DATEADD(DAY,1-DAY(@DATE),@DATE))=@DATE THEN '*' ELSE '' END+CASE W... 阅读全文