CREATE TRIGGER trigger_icstockbill ON dbo.ICStockBill
这一句里你也没有指定所在数据库啊
AIS20071215142023.dbo.ICStockBill
这一句虽然指定了所在数据库
从错误提示看 应该还是一同一个数据库下的同一个表操作的
第一句里加上所在数据库名称,试试!
呵呵!个人建议!
这一句里你也没有指定所在数据库啊
AIS20071215142023.dbo.ICStockBill
这一句虽然指定了所在数据库
从错误提示看 应该还是一同一个数据库下的同一个表操作的
第一句里加上所在数据库名称,试试!
呵呵!个人建议!
CREATE TRIGGER trigger_icstockbill ON dbo.ICStockBill
after INSERT
AS
insert AIS20071215142023.dbo.ICStockBill
select * from inserted where 主键 not in (select 主键 from AIS20071215142023.dbo.ICStockBill )
CREATE TRIGGER trigger_icstockbill ON dbo.ICStockBill
after INSERT
AS
if not exists (select 1 from inserted a,AIS20071215142023.dbo.ICStockBill b where a.主键1=b.主键1 and a.主键2=b.主键2 and a.主键3=b.主键3)
insert AIS20071215142023.dbo.ICStockBill
select * from inserted
金蝶的ERP我还是比较熟悉的,应该有的。
得再看看那个。
* TABLE NAME: ICStockBill *
* TRIGGER NAME: ICStockBill_DEL *
* CREATED BY: *
* CREATION DATE: 2005/08/01 17:04 *
* DESCRIPTION: *
******************************************************************************/
CREATE TRIGGER ICStockBill_DEL
ON dbo.ICStockBill
FOR DELETE
AS
SET NOCOUNT ON
IF EXISTS (SELECT 1 FROM DELETED WHERE FCheckerID <> 0)
BEGIN
ROLLBACK TRAN
RAISERROR('不能删除已经审核的单据!',18,18)
END
ELSE IF EXISTS (SELECT 1 FROM DELETED WHERE FCancellation = 1)
BEGIN
ROLLBACK TRAN
RAISERROR('不能删除已经作废的单据!',18,18)
END
ELSE
DELETE E
FROM ICStockBillEntry E
INNER JOIN deleted D ON E.FInterID = D.FInterID大师,你看一下,还有这个.我都快被折磨死啦!!