SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE [dbo].[vincent_TEST] ASbegin insert into GJ_COLLECTION_HEAD(GATEJOB_NO,GATEPASS_NO,TRADE_CODE,I_E_MARK,WAREHOUSE_NO,SHIPPING_NO,CORRESPOND_NO,CUSTOMS_DECLARE_NO,LICENSE_PLATE,REMARK,APP_PERSON,APP_DATE,STATUS,APPROVE_MAN,APPROVE_DATE,E_IDENTIFY_NO,FLAG1,FLAG2,REMARK1,REMARK2,OP_FLAG,CUSTOM_CODE,IS_DECLARE,STATION_REMARK,APP_ROLE,Flag3,KEY_DATE,Send_,Batch_no,obligate1,obligate2,obligate3,obligate4,END_FLAG,SUPPLY_CODE,SUPPLY_NAME,WORK_ID,WORK_FLAG,GROSS_WEIGHT,NET_WEIGHT,PKG_QTY,PKG_TYPE,PORT_TYPE,GOODS_STATUS,CHECK_STATUS,GROUND_STATUS,HOUSE_STATUS,RELATE_STATUS,LOTNO,PREFIELD1,PREFIELD2,PREFIELD3,PREFIELD4,PREFIELD5,PREFIELD6,PREFIELD7,PREFIELD8,PREFIELD9,PREFIELD10) values('GJA3223540019200810712350','A322354001920080121100022','3223540019','1','','','','','','','馬金峰','2008-10-24 09:47:24','G04','',null,'','1','','','','A','2335','0','','','','2008-10-24 09:34:15','1','','','','','','0','','','','E',0,0,0,'','','','','','','1','ECA200810240384','','','','','','','','','','')--INSERT INTO GJ_COMMON_HEAD (GATEJOB_NO,I_E_MARK,TRADE_CODE,TRADE_NAME,EMS_NO,CORRESPOND_NO,LINKMAN,PHONE,PROVIDER_CODE,PROVIDER_NAME,BIZ_ATTR,CONTRACT_NO,LICENSE_PLATE,REMARK,STATUS,E_IDENTIFY_NO,FLAG1,FLAG2,REMARK1,REMARK2,APP_PERSON,APPROVE_MAN,OP_FLAG,CUSTOM_CODE,KEY_DATE,STATION_REMARK,OBLIGATE1,OBLIGATE2,OBLIGATE3,OBLIGATE4,END_FLAG,SUPPLY_CODE,SUPPLY_NAME,WORK_FLAG,GROSS_WEIGHT,NET_WEIGHT,PKG_QTY,PKG_TYPE,GOODS_NATURE,PORT_TYPE) VALUES ('GJF2335100001200801210001','1','2335100001','纬创电子(昆山)有限公司','','','admin','22222','9999999999','苏州森六科技塑业有限公司','0','','','','G04','','','','','A01-7C0001','it21103','','','2335','2008-01-04 17:19:29','','','','','','','','','X',0,0,0,'','3','')--insert into GJ_ENTRY_HEAD(GateJob_No,FEE_RATE,INSUR_MARK,FEE_CURR,FEE_MARK,PAY_WAY,CONTAINER_NO,TRANS_MODE,CUT_MODE,TRADE_MODE,TRADE_COUNTRY,BILL_NO,IN_RATIO,CONTR_NO,AGENT_NAME,AGENT_CODE,OWNER_NAME,OWNER_CODE,DISTRICT_CODE,TRADE_NAME,TRADE_CO,TRAF_MODE,VOYAGE_NO,TRAF_NAME,DESTINATION_PORT,D_DATE,I_E_DATE,I_E_PORT,I_E_FLAG,ID_CHK,PRE_ENTRY_ID,ENTRY_ID,INSUR_CURR,INSUR_RATE,OTHER_MARK,OTHER_CURR,OTHER_RATE,PACK_NO,GROSS_WT,NET_WT,WRAP_TYPE,MANUAL_NO,LICENSE_NO,APPR_NO,NOTE_S,DECL_PORT,CO_OWNER,TAXY_RG_NO,MNL_JGF_FLAG,SERVICE_FEE,SERVICE_RATE,RELATIVE_ID,BONDED_NO,BP_NO,TYPIST_NO,P_DATE,CTA_CHK_RESULT,MODI_NO,EDI_ID,STATUS_RESULT,DECLARE_NO,JOU_EVENT,JOU_FLAG,EDI_REMARK,PARTNER_ID,CUSTOMS_FIELD,ENTRY_TYPE,RELATIVE_MANUAL_NO,PRICE_RANGE,SPECIAL_FLAG,DELAY_DAYS,DELAY_ACCOUNT,HASH_SIGN,INPUT_NO,Trans_ID,KEY_DATE,STATUS,GOODS_NATURE,ARRIVE,CUSTOM_CODE,OtherPaper,obligate4,obligate3,obligate2,obligate1,TRADE_TYPE,BIZ_TYPE,APPROVE_DATE,END_FLAG,RATE,USETO,CONTAINER_ID,OUT_CODE,OBD_CODE,TRADE_CODE,IBD_CODE,PROVIDER_CODE,WORK_CODE,OUT_NAME,WORK_NAME,APPROVE_MAN,PROVIDER_NAME,SUPPLY_CODE,SUPPLY_NAME,TRADE_NAME_IN,DECLARE_CUSTOM,WORK_ID,WORK_FLAG,PORT_TYPE,GOOD_TYPE_ID,MBL,HBL,TRANSFER_NO,CARRY_NO,GOODS_STATUS,CHECK_STATUS,GROUND_STATUS,HOUSE_STATUS,RELATE_STATUS,QUAR_STATUS,CONS_STATUS,LOTNO,TRANSPORT_CODE,TRANSPORT_NAME) values('GJR2335100001200807910018',0,'','','','',0,'1','','0110','101','',0,'JKHTH001','测试用企业','D381074057','北京星霖通服装有限公司','1114960034','','纬创','2335100001','2','','','','2008-07-04 09:33:45','2008-07-04 09:33:45','2200','1','','','','',0,'','',0,212,123213,32132,'1','20080701001','','','','3101','','','',0,0,'','','','','2008-07-04 09:33:45','',0,'','','','','','T_G','','','1','',0,'',0,0,'','','0','2008-07-04 09:36:14','G07','1','11909','2335','','','DD381074057080704093345','','','0110','R','2008-07-04 09:36:14','0','0','','','','','2335100001','','','D381074057','','测试用企业','','','D381074057','测试用企业','纬创','3101','','G','','空运进口','ZDH070401','FDH070401','ZGDH070401','','','','','','0','','','DCR200807040003','01010101','仁和电子企业')--insert into GJ_OUTPROCESS_HEAD(GATEJOB_NO,GATEPASS_NO,TRADE_CODE,O_TYPE,I_E_MARK,LICENSE_PLATE,CORRESPOND_NO,E_IDENTIFY_NO,APP_PERSON,APP_DATE,STATUS,APPROVE_MAN,APPROVE_DATE,REMARK,FLAG1,FLAG2,REMARK1,REMARK2,OP_FLAG,CUSTOM_CODE,STATION_REMARK,KEY_DATE,END_FLAG,WORK_FLAG,GROSS_WEIGHT,NET_WEIGHT,PKG_QTY,PKG_TYPE,PORT_TYPE) values('GJB2335100001200801220001','B233510000120071121000004','2335100001','B','1','','GJB2335100001200707220007','','陈强','2007-08-01 22:11:18','G04','',null,'','1','','','','','2335','','2007-07-31 15:12:36','0','E',0,0,0,'','')--insert into GJ_OUTPROCESS_HEAD(GATEJOB_NO,GATEPASS_NO,TRADE_CODE,O_TYPE,I_E_MARK,LICENSE_PLATE,CORRESPOND_NO,E_IDENTIFY_NO,APP_PERSON,APP_DATE,STATUS,APPROVE_MAN,APPROVE_DATE,REMARK,FLAG1,FLAG2,REMARK1,REMARK2,OP_FLAG,CUSTOM_CODE,STATION_REMARK,KEY_DATE,END_FLAG,WORK_FLAG,GROSS_WEIGHT,NET_WEIGHT,PKG_QTY,PKG_TYPE) values('GJM2335100001200708120027','M233510000120070822000029','2335100001','M','2','','','','陈强','2007-08-07 16:16:00','G04','',null,'','1','','','','','2335','','2007-08-07 16:15:26','0','E',0,0,1,'1')--insert into GJ_MAINTENANCE_HEAD(GATEJOB_NO,GATEPASS_NO,TRADE_CODE,I_E_MARK,LICENSE_PLATE,CORRESPOND_NO,APP_PERSON,APP_DATE,STATUS,APPROVE_MAN,APPROVE_DATE,E_IDENTIFY_NO,REMARK,FLAG1,FLAG2,REMARK1,REMARK2,OP_FLAG,CUSTOM_CODE,STATION_REMARK,KEY_DATE,END_FLAG,WORK_FLAG,GROSS_WEIGHT,NET_WEIGHT,PKG_QTY,PKG_TYPE) values('GJD2335100001200707110001','D233510000120070722000017','2335100001','1','','GJD2335100001200707220009','陈强','2007-07-31 15:40:37','G04','苏州系统管理员','2007-07-31 15:43:02','','','1','','','','','2335','','2007-07-31 15:01:54','1','E',0,0,0,'')--insert into GJ_EXCHANGE_HEAD(GATEJOB_NO,GATEPASS_NO,TRADE_CODE,I_E_MARK,LICENSE_PLATE,CORRESPOND_NO,STATUS,REMARK,APP_DATE,APPROVE_DATE,E_IDENTIFY_NO,FLAG1,FLAG2,REMARK1,REMARK2,APPROVE_MAN,APP_PERSON,OP_FLAG,CUSTOM_CODE,STATION_REMARK,KEY_DATE,END_FLAG,WORK_FLAG,GROSS_WEIGHT,NET_WEIGHT,PKG_QTY,PKG_TYPE) values('GJE2335100001200707210001','E233510000120070721000007','2335100001','1','','','G04','','2007-07-31 17:21:33',null,'','1','','','','','admin','A','2335','','2007-07-31 00:00:00','0','P',0,0,0,'')select getdate() as aa,GATEJOB_NO,GATEPASS_NO from GJ_COLLECTION_HEAD where GATEJOB_NO='GJA3223540019200810712350'select * from APPROVE_TRACES where order_no='GJA3223540019200810712350'end GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
在存储过程第一句前面加上： set nocount on
做了个测试，感觉没啥问题，可能你的触发器写得有问题？…… create table tb(id int) gocreate trigger tri on tb instead of insert as insert tb select id+100 from inserted gocreate proc p as insert tb values(1) goexec p goselect * from tb /* id ----------- 101 */drop proc p drop table tb
代码贴出来look look
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE [dbo].[vincent_TEST] ASbegin
insert into GJ_COLLECTION_HEAD(GATEJOB_NO,GATEPASS_NO,TRADE_CODE,I_E_MARK,WAREHOUSE_NO,SHIPPING_NO,CORRESPOND_NO,CUSTOMS_DECLARE_NO,LICENSE_PLATE,REMARK,APP_PERSON,APP_DATE,STATUS,APPROVE_MAN,APPROVE_DATE,E_IDENTIFY_NO,FLAG1,FLAG2,REMARK1,REMARK2,OP_FLAG,CUSTOM_CODE,IS_DECLARE,STATION_REMARK,APP_ROLE,Flag3,KEY_DATE,Send_,Batch_no,obligate1,obligate2,obligate3,obligate4,END_FLAG,SUPPLY_CODE,SUPPLY_NAME,WORK_ID,WORK_FLAG,GROSS_WEIGHT,NET_WEIGHT,PKG_QTY,PKG_TYPE,PORT_TYPE,GOODS_STATUS,CHECK_STATUS,GROUND_STATUS,HOUSE_STATUS,RELATE_STATUS,LOTNO,PREFIELD1,PREFIELD2,PREFIELD3,PREFIELD4,PREFIELD5,PREFIELD6,PREFIELD7,PREFIELD8,PREFIELD9,PREFIELD10) values('GJA3223540019200810712350','A322354001920080121100022','3223540019','1','','','','','','','馬金峰','2008-10-24 09:47:24','G04','',null,'','1','','','','A','2335','0','','','','2008-10-24 09:34:15','1','','','','','','0','','','','E',0,0,0,'','','','','','','1','ECA200810240384','','','','','','','','','','')--INSERT INTO GJ_COMMON_HEAD (GATEJOB_NO,I_E_MARK,TRADE_CODE,TRADE_NAME,EMS_NO,CORRESPOND_NO,LINKMAN,PHONE,PROVIDER_CODE,PROVIDER_NAME,BIZ_ATTR,CONTRACT_NO,LICENSE_PLATE,REMARK,STATUS,E_IDENTIFY_NO,FLAG1,FLAG2,REMARK1,REMARK2,APP_PERSON,APPROVE_MAN,OP_FLAG,CUSTOM_CODE,KEY_DATE,STATION_REMARK,OBLIGATE1,OBLIGATE2,OBLIGATE3,OBLIGATE4,END_FLAG,SUPPLY_CODE,SUPPLY_NAME,WORK_FLAG,GROSS_WEIGHT,NET_WEIGHT,PKG_QTY,PKG_TYPE,GOODS_NATURE,PORT_TYPE) VALUES ('GJF2335100001200801210001','1','2335100001','纬创电子(昆山)有限公司','','','admin','22222','9999999999','苏州森六科技塑业有限公司','0','','','','G04','','','','','A01-7C0001','it21103','','','2335','2008-01-04 17:19:29','','','','','','','','','X',0,0,0,'','3','')--insert into GJ_ENTRY_HEAD(GateJob_No,FEE_RATE,INSUR_MARK,FEE_CURR,FEE_MARK,PAY_WAY,CONTAINER_NO,TRANS_MODE,CUT_MODE,TRADE_MODE,TRADE_COUNTRY,BILL_NO,IN_RATIO,CONTR_NO,AGENT_NAME,AGENT_CODE,OWNER_NAME,OWNER_CODE,DISTRICT_CODE,TRADE_NAME,TRADE_CO,TRAF_MODE,VOYAGE_NO,TRAF_NAME,DESTINATION_PORT,D_DATE,I_E_DATE,I_E_PORT,I_E_FLAG,ID_CHK,PRE_ENTRY_ID,ENTRY_ID,INSUR_CURR,INSUR_RATE,OTHER_MARK,OTHER_CURR,OTHER_RATE,PACK_NO,GROSS_WT,NET_WT,WRAP_TYPE,MANUAL_NO,LICENSE_NO,APPR_NO,NOTE_S,DECL_PORT,CO_OWNER,TAXY_RG_NO,MNL_JGF_FLAG,SERVICE_FEE,SERVICE_RATE,RELATIVE_ID,BONDED_NO,BP_NO,TYPIST_NO,P_DATE,CTA_CHK_RESULT,MODI_NO,EDI_ID,STATUS_RESULT,DECLARE_NO,JOU_EVENT,JOU_FLAG,EDI_REMARK,PARTNER_ID,CUSTOMS_FIELD,ENTRY_TYPE,RELATIVE_MANUAL_NO,PRICE_RANGE,SPECIAL_FLAG,DELAY_DAYS,DELAY_ACCOUNT,HASH_SIGN,INPUT_NO,Trans_ID,KEY_DATE,STATUS,GOODS_NATURE,ARRIVE,CUSTOM_CODE,OtherPaper,obligate4,obligate3,obligate2,obligate1,TRADE_TYPE,BIZ_TYPE,APPROVE_DATE,END_FLAG,RATE,USETO,CONTAINER_ID,OUT_CODE,OBD_CODE,TRADE_CODE,IBD_CODE,PROVIDER_CODE,WORK_CODE,OUT_NAME,WORK_NAME,APPROVE_MAN,PROVIDER_NAME,SUPPLY_CODE,SUPPLY_NAME,TRADE_NAME_IN,DECLARE_CUSTOM,WORK_ID,WORK_FLAG,PORT_TYPE,GOOD_TYPE_ID,MBL,HBL,TRANSFER_NO,CARRY_NO,GOODS_STATUS,CHECK_STATUS,GROUND_STATUS,HOUSE_STATUS,RELATE_STATUS,QUAR_STATUS,CONS_STATUS,LOTNO,TRANSPORT_CODE,TRANSPORT_NAME) values('GJR2335100001200807910018',0,'','','','',0,'1','','0110','101','',0,'JKHTH001','测试用企业','D381074057','北京星霖通服装有限公司','1114960034','','纬创','2335100001','2','','','','2008-07-04 09:33:45','2008-07-04 09:33:45','2200','1','','','','',0,'','',0,212,123213,32132,'1','20080701001','','','','3101','','','',0,0,'','','','','2008-07-04 09:33:45','',0,'','','','','','T_G','','','1','',0,'',0,0,'','','0','2008-07-04 09:36:14','G07','1','11909','2335','','','DD381074057080704093345','','','0110','R','2008-07-04 09:36:14','0','0','','','','','2335100001','','','D381074057','','测试用企业','','','D381074057','测试用企业','纬创','3101','','G','','空运进口','ZDH070401','FDH070401','ZGDH070401','','','','','','0','','','DCR200807040003','01010101','仁和电子企业')--insert into GJ_OUTPROCESS_HEAD(GATEJOB_NO,GATEPASS_NO,TRADE_CODE,O_TYPE,I_E_MARK,LICENSE_PLATE,CORRESPOND_NO,E_IDENTIFY_NO,APP_PERSON,APP_DATE,STATUS,APPROVE_MAN,APPROVE_DATE,REMARK,FLAG1,FLAG2,REMARK1,REMARK2,OP_FLAG,CUSTOM_CODE,STATION_REMARK,KEY_DATE,END_FLAG,WORK_FLAG,GROSS_WEIGHT,NET_WEIGHT,PKG_QTY,PKG_TYPE,PORT_TYPE) values('GJB2335100001200801220001','B233510000120071121000004','2335100001','B','1','','GJB2335100001200707220007','','陈强','2007-08-01 22:11:18','G04','',null,'','1','','','','','2335','','2007-07-31 15:12:36','0','E',0,0,0,'','')--insert into GJ_OUTPROCESS_HEAD(GATEJOB_NO,GATEPASS_NO,TRADE_CODE,O_TYPE,I_E_MARK,LICENSE_PLATE,CORRESPOND_NO,E_IDENTIFY_NO,APP_PERSON,APP_DATE,STATUS,APPROVE_MAN,APPROVE_DATE,REMARK,FLAG1,FLAG2,REMARK1,REMARK2,OP_FLAG,CUSTOM_CODE,STATION_REMARK,KEY_DATE,END_FLAG,WORK_FLAG,GROSS_WEIGHT,NET_WEIGHT,PKG_QTY,PKG_TYPE) values('GJM2335100001200708120027','M233510000120070822000029','2335100001','M','2','','','','陈强','2007-08-07 16:16:00','G04','',null,'','1','','','','','2335','','2007-08-07 16:15:26','0','E',0,0,1,'1')--insert into GJ_MAINTENANCE_HEAD(GATEJOB_NO,GATEPASS_NO,TRADE_CODE,I_E_MARK,LICENSE_PLATE,CORRESPOND_NO,APP_PERSON,APP_DATE,STATUS,APPROVE_MAN,APPROVE_DATE,E_IDENTIFY_NO,REMARK,FLAG1,FLAG2,REMARK1,REMARK2,OP_FLAG,CUSTOM_CODE,STATION_REMARK,KEY_DATE,END_FLAG,WORK_FLAG,GROSS_WEIGHT,NET_WEIGHT,PKG_QTY,PKG_TYPE) values('GJD2335100001200707110001','D233510000120070722000017','2335100001','1','','GJD2335100001200707220009','陈强','2007-07-31 15:40:37','G04','苏州系统管理员','2007-07-31 15:43:02','','','1','','','','','2335','','2007-07-31 15:01:54','1','E',0,0,0,'')--insert into GJ_EXCHANGE_HEAD(GATEJOB_NO,GATEPASS_NO,TRADE_CODE,I_E_MARK,LICENSE_PLATE,CORRESPOND_NO,STATUS,REMARK,APP_DATE,APPROVE_DATE,E_IDENTIFY_NO,FLAG1,FLAG2,REMARK1,REMARK2,APPROVE_MAN,APP_PERSON,OP_FLAG,CUSTOM_CODE,STATION_REMARK,KEY_DATE,END_FLAG,WORK_FLAG,GROSS_WEIGHT,NET_WEIGHT,PKG_QTY,PKG_TYPE) values('GJE2335100001200707210001','E233510000120070721000007','2335100001','1','','','G04','','2007-07-31 17:21:33',null,'','1','','','','','admin','A','2335','','2007-07-31 00:00:00','0','P',0,0,0,'')select getdate() as aa,GATEJOB_NO,GATEPASS_NO from GJ_COLLECTION_HEAD where GATEJOB_NO='GJA3223540019200810712350'select * from APPROVE_TRACES where order_no='GJA3223540019200810712350'end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
set nocount on
create table tb(id int)
gocreate trigger tri on tb instead of insert
as
insert tb select id+100 from inserted
gocreate proc p
as
insert tb values(1)
goexec p
goselect * from tb
/*
id
-----------
101
*/drop proc p
drop table tb