【MSSql2000】触发器

CREATE TRIGGER [TimeToWeekAdd] ON [dbo].[OlympicTime] FOR INSERTASdeclare @timedetails smalldatetimedeclare @timeweek intselect @timedetails=OTimeBegin from insertedset datefirst 1select @timeweek=datepart(dw,@timedetails)update OlympicTime set OTimeWeek=case @timeweek when 1 then '星期一' when 2 then '星期二'when 3 then '星期三'when 4 then '星期四'when 5 then '星期五'when 6 then '星期六'when 7 then '星期日'end where OTimeID in (select OTimeID from inserted)CREATE TRIGGER [TimeToWeekUpdate] ON [dbo].[OlympicTime] FOR  UPDATE ASdeclare @timedetails smalldatetimedeclare @timeweek intselect @timedetails=OTimeBegin from insertedset datefirst 1select @timeweek=DATEPART(dw,@timedetails)if Update (OTimeBegin) beginupdate OlympicTime set OTimeWeek=case @timeweek when 1 then '星期一' when 2 then '星期二'when 3 then '星期三'when 4 then '星期四'when 5 then '星期五'when 6 then '星期六'when 7 then '星期日'end where OTimeID in (select OTimeID from inserted)end