现有A表和B表
A表上有触发器
我想实现的是,当我向A表中插入数据时,也向B表插入数据
我找了些方法:alter table 表 disable trigger 触发器名
alter table 表 enable trigger 触发器名 但是没有效果,求帮助
A表上有触发器
我想实现的是,当我向A表中插入数据时,也向B表插入数据
我找了些方法:alter table 表 disable trigger 触发器名
alter table 表 enable trigger 触发器名 但是没有效果,求帮助
ON [dbo].[PE_Users]
For INSERT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for trigger here
DECLARE @Email nvarchar(50),@UserName nvarchar(50),@Realname nvarchar(50),@Password nvarchar(50)
DECLARE @IP nvarchar(50),@Login_time datetime, @Create_time Datetime,@Alipay_UserID nvarchar(20)
Declare curINSERT Cursor For
Select Email,UserName,TrueName,UserPassword,isNull(LastLoginIP,'') as IP,
isNull(LastLoginTime,getdate()) as Login_time,RegTime,Alipay_UserID From INSERTED Open curINSERT -- 打开游标
FETCH NEXT FROM curINSERT into @Email,@UserName,@Realname,@Password,@IP,@Login_time,@Create_time,@Alipay_UserID WHILE @@FETCH_STATUS = 0
BEGIN
if NOT EXISTS(Select UserName From tuan_3_8.dbo.[User] Where UserName=@UserName)
begin
INSERT INTO tuan_3_8.dbo.[User](Email,UserName,Realname,[Password],Avatar,
Gender,Newbie,City_id,[Enable],Manager,IP,Login_time,Create_time,Alipay_UserID) VALUES(
@Email,@UserName,@Realname,@Password,'/upfile/img/user-no-avatar.gif','M',
'N',2,'Y','N',@IP,@Login_time,@Create_time,@Alipay_UserID)
END
FETCH NEXT FROM curINSERT into @Email,@UserName,@Realname,@Password,@IP,@Login_time,@Create_time,@Alipay_UserID
END
Close curINSERT --关闭游标
Deallocate curINSERT --释放游标
END