【MSSql2000】触发器

CREATE TRIGGER [TimeToWeekAdd] ON [dbo].[OlympicTime] 
FOR INSERT
AS
declare @timedetails smalldatetime
declare @timeweek int
select @timedetails=OTimeBegin from inserted
set datefirst 1
select @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 
AS
declare @timedetails smalldatetime
declare @timeweek int
select @timedetails=OTimeBegin from inserted
set datefirst 1
select @timeweek=DATEPART(dw,@timedetails)
if Update (OTimeBegin) begin
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)
end