触发器的内容是这个...我看不懂....刚刚接触数据库...
USE [db_fb]
GO
/****** Object: Trigger [dbo].[t_PrvMst_update] Script Date: 11/20/2017 09:57:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[t_PrvMst_update] ON [dbo].[t_prvmst]
FOR update
AS
BEGIN
BEGIN
--备份到另一个数据库
INSERT INTO db_fb_Del.dbo.t_PrvMst
SELECT *,GETDATE(),HOST_NAME()+'update'
FROM deleted
END
END[/quote]
这个插入的表的字段和select出来的字段对应不上,应该是表字段少了,插入的时候最好写上列名字,方便后期维护
触发器的内容是这个...我看不懂....刚刚接触数据库...
USE [db_fb]
GO
/****** Object: Trigger [dbo].[t_PrvMst_update] Script Date: 11/20/2017 09:57:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[t_PrvMst_update] ON [dbo].[t_prvmst]
FOR update
AS
BEGIN
BEGIN
--备份到另一个数据库
INSERT INTO db_fb_Del.dbo.t_PrvMst
SELECT *,GETDATE(),HOST_NAME()+'update'
FROM deleted
END
END
触发器的内容是这个...我看不懂....刚刚接触数据库...
USE [db_fb]
GO
/****** Object: Trigger [dbo].[t_PrvMst_update] Script Date: 11/20/2017 09:57:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[t_PrvMst_update] ON [dbo].[t_prvmst]
FOR update
AS
BEGIN
BEGIN
--备份到另一个数据库
INSERT INTO db_fb_Del.dbo.t_PrvMst
SELECT *,GETDATE(),HOST_NAME()+'update'
FROM deleted
END
END
触发器的内容是这个...我看不懂....刚刚接触数据库...
USE [db_fb]
GO
/****** Object: Trigger [dbo].[t_PrvMst_update] Script Date: 11/20/2017 09:57:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[t_PrvMst_update] ON [dbo].[t_prvmst]
FOR update
AS
BEGIN
BEGIN
--备份到另一个数据库
INSERT INTO db_fb_Del.dbo.t_PrvMst
SELECT *,GETDATE(),HOST_NAME()+'update'
FROM deleted
END
END[/quote]
1、update这个表t_PrvMst的时候,再想这个表插入数据?不对劲儿吧,是不是应该插入到备份表
2、还有insert t_PrvMst 这个表然后数据是select t_PrvMst +GETDATE() , HOST_NAME() + 'update',那t_PrvMst 表的字段肯定不沟通。
3、for update 触发器中的临时表用inserted不用deleted