--if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ICStockBill_insert]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)--drop trigger [ICStockBill_insert]--GO/****************************************************************************** * TABLE NAME: ICStockBill * * TRIGGER NAME: ICStockBill_insert * * CREATED BY: wucy * * CREATION DATE: 2011/07/11 * * DESCRIPTION: 防止出入单据日期输错很多年,如2011-07-01 输错2111-07-01, * * 导致长时间的收发报表结存为负 * ******************************************************************************/CREATE TRIGGER [dbo].[ICStockBill_insert] ON [dbo].[ICStockBill]FOR insert,updateAS declare @fdate datetimedeclare @day_no int select @fdate=a.fdate from ICStockBill a inner join inserted b on a.finterid=b.finterid SELECT @day_no=DATEDIFF(month,(SELECT CONVERT(VARCHAR(10),GETDATE(),120)),@fdate) IF @day_no>2 BEGIN ROLLBACK TRAN RAISERROR('制单日期不能超后2月!',18,18) END