USE [S_heyday]
GO
/* Object: Trigger [seller_delete] Script Date: 2018/6/5 11:47:32 */
DROP TRIGGER [dbo].[seller_delete]
GO
/* Object: Trigger [dbo].[seller_delete] Script Date: 2018/6/5 11:47:32 */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[seller_delete]
ON [dbo].[S_Seller]
FOR DELETE
AS
INSERT INTO S_del_seller
(CompanyType, CreateTime, UpdateTime)
SELECT CompanyType,GETDATE(), UpdateTime
FROM deleted
GO