想哭，不知错在那？

Question

我这个是放在触发器中，一加这一句，前端程序新增时，死在那：
CREATE TRIGGER [orderformdetail_insert] ON dbo.orderformdetail 
FOR INSERT 
AS
insert noproduce_informdetail (orderformid,orderformitem,productid,tiepian,orderquantity,deliverydate,silk_screenid)
select orderformid,orderformitem,productid,tiepian,orderquantity,deliverydatetime,silk_screenid from insertedinsert nodeliverydetail (customerid,orderformid,orderformitem,orderquantity,deliverydate)
select   o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid

Answer 1

我这个是放在触发器中，
CREATE TRIGGER [orderformdetail_insert] ON dbo.orderformdetail 
FOR INSERT 
AS
这一句没有问题，调试时
insert noproduce_informdetail (orderformid,orderformitem,productid,tiepian,orderquantity,deliverydate,silk_screenid)
select orderformid,orderformitem,productid,tiepian,orderquantity,deliverydatetime,silk_screenid from inserted一加这一句，前端程序新增订单，运行过POST，死在那
insert nodeliverydetail (customerid,orderformid,orderformitem,orderquantity,deliverydate)
select   o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid

Answer 2

把下面這段先去掉，然後在前段測試POST,
再把這句加到裡面單獨執行試試，看有沒有什麼問題？
-----------------------------------------------------------------------------
--一加这一句，前端程序新增订单，运行过POST，死在那
insert nodeliverydetail (customerid,orderformid,orderformitem,orderquantity,deliverydate)
select   o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid

Answer 3

删除前一句，测试通不过，没用!
我用的是MSSQL2000，日志在那看？

Answer 4

在企业管理器 SERVER 的管理里面可以看日志（用sa登录).

Answer 5

insert nodeliverydetail (customerid,orderformid,orderformitem,orderquantity,deliverydate)
select   o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid
是否有一对多的，主键重复？

Answer 6

没有啊，只有orderform(订单表)的orderformid为主键，还有nodeliverydetail 没有设主键
也没有做触发器

Answer 7

把下面這段先去掉，然後在前段測試POST,
再把這句放到sqlserver analyze裡手動單獨執行試試，看有沒有什麼問題？
-----------------------------------------------------------------------------
--一加这一句，前端程序新增订单，运行过POST，死在那
insert nodeliverydetail (customerid,orderformid,orderformitem,orderquantity,deliverydate)
select   o.customerid,i.orderformid,i.orderformitem,i.orderquantity,i.deliverydatetime from inserted i, orderform o
where o.orderformid=i.orderformid