触发器的内容是这个...我看不懂....刚刚接触数据库...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 这个插入的表的字段和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 1、update这个表t_PrvMst的时候,再想这个表插入数据?不对劲儿吧,是不是应该插入到备份表 2、还有insert t_PrvMst 这个表然后数据是select t_PrvMst +GETDATE() , HOST_NAME() + 'update',那t_PrvMst 表的字段肯定不沟通。 3、for update 触发器中的临时表用inserted不用deleted
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
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
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
这个插入的表的字段和select出来的字段对应不上,应该是表字段少了,插入的时候最好写上列名字,方便后期维护
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
1、update这个表t_PrvMst的时候,再想这个表插入数据?不对劲儿吧,是不是应该插入到备份表
2、还有insert t_PrvMst 这个表然后数据是select t_PrvMst +GETDATE() , HOST_NAME() + 'update',那t_PrvMst 表的字段肯定不沟通。
3、for update 触发器中的临时表用inserted不用deleted