1 create trigger a on table for update,insert as if exists(select * from inserted where 条件) insert into b select * from inserted where 条件2可以阿,应该是你的存储过程或者调用有问题,代码?!
我在IDE中如何提取到数据呢?
CREATE PROC dRegister @p_SrcNo varchar AS set nocount on delete from register where SrcNo=@p_SrcNo GO
create trigger a on table
for update,insert
as
if exists(select * from inserted where 条件)
insert into b
select * from inserted where 条件2可以阿,应该是你的存储过程或者调用有问题,代码?!
@p_SrcNo varchar
AS
set nocount on
delete from register where SrcNo=@p_SrcNo
GO