各位帮忙看下,我在sqlserver2000上放下边的触发器后原来的向pki插入数据就不能成功,去掉触发器就没问题alter trigger pki_insertdate ---pki插入数据更新pkip02
on pki
after insert
as
begin
declare @id decimal
declare @pkiibd decimal
declare @ibdcon nvarchar(50)
select @pkiibd=pkiibd,@id=id from inserted ---获取pki的id、pkiibd
select @ibdcon=ibdcon from ibd where id=@pkiibd --获取ibdcon
update pki set pkip02=@ibdcon where id=@id
end
on pki
after insert
as
begin
declare @id decimal
declare @pkiibd decimal
declare @ibdcon nvarchar(50)
select @pkiibd=pkiibd,@id=id from inserted ---获取pki的id、pkiibd
select @ibdcon=ibdcon from ibd where id=@pkiibd --获取ibdcon
update pki set pkip02=@ibdcon where id=@id
end
select top 1 @ibdcon=ibdcon from ibd where id=@pkiibd --获取ibdcon
改成
FOR insert
看一下可以不?
FOR insert
改成
after insert
的