【MSSql2000】触发器

关注

原创最新推荐文章于 2026-03-16 01:35:18 发布 605 阅读 AI 写同款· GEO 优化 ›

sqlserver 2000 触发器 存储过程调用外部dll，可以使vb，vc，delphi生成 使用非SQL格式dll，也就是平时所写的，如果打死也不明白就用他就可以。 dll需要事先先注册， 注册是：regsvr32 名字.dll 卸载是：regsvr32 /u 名字.dll CREATE TRIGGER [名称] ON [表名] AFTER INSERT, UPDATE, DELETE AS DECLARE @hr int DECLARE @obj int DECLARE @out varchar(200) exec @hr 阅读详情

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

收录于