(20-01-2023, Saat: 12:04)Tuğrul HELVACI Adlı Kullanıcıdan Alıntı: Neden string manüplasyonları ile uğraşıyorsunuz anlamadım açıkçası.
INSERT INTO HedefTablonuz(Alanlarınız) SELECT Alanlar FROM INSERTED
gibi bir kod ile istediğinizi yapabilirsiniz.
Bu yapılan iş senkron bir iştir. Yani kaynak tablonuzun insert trigger'ında bu işi yaptığınız için sizin insert zamanlamanıza yedekleme zamanını da ilave etmek gerekir.Performans anlamında sıkıntı yaşamak istemiyor iseniz bu işi asenkron yapmalısınız. Öyle bir durum için de Microsoft Sql Server için Service Broker kullanmalısınız.
CREATE TRIGGER ITEM_INSERT
ON LG_001_ITEMS
AFTER INSERT AS
BEGIN
DECLARE @LOGICALREF int
DECLARE @ACTIVE smallint
DECLARE @CARDTYPE smallint
DECLARE @CODE varchar(25)
DECLARE @NAME varchar(51)
DECLARE @STGRPCODE varchar(25)
DECLARE @PRODUCERCODE varchar(101)
DECLARE @SPECODE varchar(11)
DECLARE @CYPHCODE varchar(11)
DECLARE @CLASSTYPE smallint
DECLARE @PURCHBRWS smallint
DECLARE @SALESBRWS smallint
DECLARE @MTRLBRWS smallint
DECLARE @VAT float
DECLARE @PAYMENTREF int
DECLARE @TRACKTYPE smallint
DECLARE @LOCTRACKING smallint
DECLARE @TOOL smallint
DECLARE @AUTOINCSL smallint
DECLARE @DIVLOTSIZE smallint
DECLARE @SHELFLIFE float
DECLARE @SHELFDATE smallint
DECLARE @DOMINANTREFS1 int
DECLARE @DOMINANTREFS2 int
DECLARE @DOMINANTREFS3 int
DECLARE @DOMINANTREFS4 int
DECLARE @DOMINANTREFS5 int
DECLARE @DOMINANTREFS6 int
DECLARE @DOMINANTREFS7 int
DECLARE @DOMINANTREFS8 int
DECLARE @DOMINANTREFS9 int
DECLARE @DOMINANTREFS10 int
DECLARE @DOMINANTREFS11 int
DECLARE @DOMINANTREFS12 int
DECLARE @IMAGEINC smallint
DECLARE @TEXTINC smallint
DECLARE @DEPRTYPE smallint
DECLARE @DEPRRATE float
DECLARE @DEPRDUR smallint
DECLARE @SALVAGEVAL float
DECLARE @REVALFLAG smallint
DECLARE @REVDEPRFLAG smallint
DECLARE @PARTDEP smallint
DECLARE @DEPRTYPE2 smallint
DECLARE @DEPRRATE2 float
DECLARE @DEPRDUR2 smallint
DECLARE @REVALFLAG2 smallint
DECLARE @REVDEPRFLAG2 smallint
DECLARE @PARTDEP2 smallint
DECLARE @APPROVED smallint
DECLARE @UNITSETREF int
DECLARE @QCCSETREF int
DECLARE @DISTAMOUNT float
DECLARE @CAPIBLOCK_CREATEDBY smallint
DECLARE @CAPIBLOCK_CREADEDDATE datetime
DECLARE @CAPIBLOCK_CREATEDHOUR smallint
DECLARE @CAPIBLOCK_CREATEDMIN smallint
DECLARE @CAPIBLOCK_CREATEDSEC smallint
DECLARE @CAPIBLOCK_MODIFIEDBY smallint
DECLARE @CAPIBLOCK_MODIFIEDDATE datetime
DECLARE @CAPIBLOCK_MODIFIEDHOUR smallint
DECLARE @CAPIBLOCK_MODIFIEDMIN smallint
DECLARE @CAPIBLOCK_MODIFIEDSEC smallint
DECLARE @SITEID smallint
DECLARE @RECSTATUS smallint
DECLARE @ORGLOGICREF int
DECLARE @UNIVID varchar(25)
DECLARE @DISTLOTUNITS smallint
DECLARE @COMBLOTUNITS smallint
DECLARE @WFSTATUS int
DECLARE @DISTPOINT float
DECLARE @CAMPPOINT float
DECLARE @CANUSEINTRNS smallint
DECLARE @ISONR varchar(11)
DECLARE @GROUPNR varchar(9)
DECLARE @PRODCOUNTRY varchar(13)
DECLARE @ADDTAXREF int
DECLARE @QPRODAMNT float
DECLARE @QPRODUOM int
DECLARE @QPRODSRCINDEX smallint
DECLARE @EXTACCESSFLAGS int
DECLARE @PACKET smallint
DECLARE @SALVAGEVAL2 float
DECLARE @SELLVAT float
DECLARE @RETURNVAT float
DECLARE @LOGOID varchar(25)
DECLARE @LIDCONFIRMED smallint
DECLARE @GTIPCODE varchar(25)
DECLARE @EXPCTGNO varchar(25)
DECLARE @B2CCODE varchar(25)
DECLARE @MARKREF int
DECLARE @IMAGE2INC smallint
DECLARE @AVRWHDURATION float
DECLARE @EXTCARDFLAGS int
DECLARE @MINORDAMOUNT float
DECLARE @FREIGHTPLACE varchar(51)
DECLARE @FREIGHTTYPCODE1 varchar(13)
DECLARE @FREIGHTTYPCODE2 varchar(13)
DECLARE @FREIGHTTYPCODE3 varchar(13)
DECLARE @FREIGHTTYPCODE4 varchar(13)
DECLARE @FREIGHTTYPCODE5 varchar(13)
DECLARE @FREIGHTTYPCODE6 varchar(13)
DECLARE @FREIGHTTYPCODE7 varchar(13)
DECLARE @FREIGHTTYPCODE8 varchar(13)
DECLARE @FREIGHTTYPCODE9 varchar(13)
DECLARE @FREIGHTTYPCODE10 varchar(13)
DECLARE @STATECODE varchar(13)
DECLARE @STATENAME varchar(41)
DECLARE @EXPCATEGORY varchar(25)
DECLARE @LOSTFACTOR float
DECLARE @TEXTINCENG smallint
DECLARE @EANBARCODE varchar(25)
DECLARE @DEPRCLASSTYPE varchar(31)
DECLARE @WFLOWCRDREF int
DECLARE @SELLPRVAT float
DECLARE @RETURNPRVAT float
DECLARE @LOWLEVELCODES1 int
DECLARE @LOWLEVELCODES2 int
DECLARE @LOWLEVELCODES3 int
DECLARE @LOWLEVELCODES4 int
DECLARE @LOWLEVELCODES5 int
DECLARE @LOWLEVELCODES6 int
DECLARE @LOWLEVELCODES7 int
DECLARE @LOWLEVELCODES8 int
DECLARE @LOWLEVELCODES9 int
DECLARE @LOWLEVELCODES10 int
DECLARE @ORGLOGOID varchar(25)
DECLARE @QPRODDEPART smallint
DECLARE @CANCONFIGURE smallint
DECLARE @CHARSETREF int
DECLARE @CANDEDUCT smallint
DECLARE @CONSCODEREF int
DECLARE @SPECODE2 varchar(11)
DECLARE @SPECODE3 varchar(11)
DECLARE @SPECODE4 varchar(11)
DECLARE @SPECODE5 varchar(11)
DECLARE @EXPENSE smallint
DECLARE @ORIGIN varchar(25)
DECLARE @NAME2 varchar(51)
DECLARE @COMPKDVUSE smallint
DECLARE @USEDINPERIODS smallint
DECLARE @EXIMTAX1 float
DECLARE @EXIMTAX2 float
DECLARE @EXIMTAX3 float
DECLARE @EXIMTAX4 float
DECLARE @EXIMTAX5 float
DECLARE @PRODUCTLEVEL smallint
DECLARE @APPSPEVATMATRAH smallint
DECLARE @NAME3 varchar(201)
DECLARE @FACOSTKEYS smallint
DECLARE @KKLINESDISABLE smallint
DECLARE @APPROVE smallint
DECLARE @APPROVEDATE datetime
DECLARE @GLOBALID varchar(51)
DECLARE @SALEDEDUCTPART1 smallint
DECLARE @SALEDEDUCTPART2 smallint
DECLARE @PURCDEDUCTPART1 smallint
DECLARE @PURCDEDUCTPART2 smallint
DECLARE @CATEGORYID varchar(51)
DECLARE @CATEGORYNAME varchar(256)
DECLARE @KEYWORD1 varchar(121)
DECLARE @KEYWORD2 varchar(121)
DECLARE @KEYWORD3 varchar(121)
DECLARE @KEYWORD4 varchar(121)
DECLARE @KEYWORD5 varchar(121)
DECLARE @GUID varchar(37)
DECLARE @DEMANDMEETSORTFLD1 varchar(51)
DECLARE @DEMANDMEETSORTFLD2 varchar(51)
DECLARE @DEMANDMEETSORTFLD3 varchar(51)
DECLARE @DEMANDMEETSORTFLD4 varchar(51)
DECLARE @DEMANDMEETSORTFLD5 varchar(51)
DECLARE @DEDUCTCODE varchar(11)
DECLARE @PROJECTREF int
DECLARE @NAME4 varchar(201)
DECLARE @QPRODSUBAMNT float
DECLARE @QPRODSUBUOM int
DECLARE @QPRODSUBSRCINDEX smallint
DECLARE @QPRODSUBDEPART smallint
DECLARE @PORDAMNTTOLERANCE float
DECLARE @SORDAMNTTOLERANCE float
DECLARE @MULTIADDTAX smallint
DECLARE @CPACODE varchar(25)
DECLARE @PUBLICCOUNTRYREF int
DECLARE @FAUSEFULLIFECODE varchar(11)
DECLARE @FAUSEFULLIFECODE2 varchar(11)
DECLARE @MOLD smallint
DECLARE @MOLDLIFETRACKTYPE smallint
DECLARE @MOLDUSAGELIFE float
DECLARE @MOLDFACTOR smallint
DECLARE @MOLDMAINTNUMBER int
DECLARE @MOLDMAINTLIFETYPE smallint
DECLARE @MOLDMAINTLIFE float
DECLARE @MOLDLIFEASRATIO smallint
DECLARE @MOLDMAINTTYPE smallint
DECLARE @MOLDMAINTBEGDATE datetime
DECLARE @MOLDMAINTPERIOD float
DECLARE @MOLDMAINTPERUNIT smallint
DECLARE @OBTAINTYPE smallint
DECLARE @GAINTYPE smallint
DECLARE @FORECASTCODE varchar(25)
DECLARE @SALESLIMITQUANTITY float
DECLARE @NODISCOUNT smallint
DECLARE @LEVELCONTROL smallint
DECLARE @NOTIFYCRDREF int
DECLARE @UETDSUNCODE varchar(9)
DECLARE @UETDSUNDEF varchar(256)
DECLARE @UETDSLOADUNIT varchar(5)
DECLARE @UETDSTRANSPORTMODE smallint
DECLARE @UETDSTRANSPORTTYPE smallint
DECLARE @UETDSLOADTYPE varchar(5)
DECLARE @UETDSLOADTYPEDEF varchar(256)
SELECT @LOGICALREF=LOGICALREF,
@ACTIVE=ACTIVE,
@CARDTYPE=CARDTYPE,
@CODE=CODE,
@NAME=NAME,
@STGRPCODE=STGRPCODE,
@PRODUCERCODE=PRODUCERCODE,
@SPECODE=SPECODE,
@CYPHCODE=CYPHCODE,
@CLASSTYPE=CLASSTYPE,
@PURCHBRWS=PURCHBRWS,
@SALESBRWS=SALESBRWS,
@MTRLBRWS=MTRLBRWS,
@VAT=VAT,
@PAYMENTREF=PAYMENTREF,
@TRACKTYPE=TRACKTYPE,
@LOCTRACKING=LOCTRACKING,
@TOOL=TOOL,
@AUTOINCSL=AUTOINCSL,
@DIVLOTSIZE=DIVLOTSIZE,
@SHELFLIFE=SHELFLIFE,
@SHELFDATE=SHELFDATE,
@DOMINANTREFS1=DOMINANTREFS1,
@DOMINANTREFS2=DOMINANTREFS2,
@DOMINANTREFS3=DOMINANTREFS3,
@DOMINANTREFS4=DOMINANTREFS4,
@DOMINANTREFS5=DOMINANTREFS5,
@DOMINANTREFS6=DOMINANTREFS6,
@DOMINANTREFS7=DOMINANTREFS7,
@DOMINANTREFS8=DOMINANTREFS8,
@DOMINANTREFS9=DOMINANTREFS9,
@DOMINANTREFS10=DOMINANTREFS10,
@DOMINANTREFS11=DOMINANTREFS11,
@DOMINANTREFS12=DOMINANTREFS12,
@IMAGEINC=IMAGEINC,
@TEXTINC=TEXTINC,
@DEPRTYPE=DEPRTYPE,
@DEPRRATE=DEPRRATE,
@DEPRDUR=DEPRDUR,
@SALVAGEVAL=SALVAGEVAL,
@REVALFLAG=REVALFLAG,
@REVDEPRFLAG=REVDEPRFLAG,
@PARTDEP=PARTDEP,
@DEPRTYPE2=DEPRTYPE2,
@DEPRRATE2=DEPRRATE2,
@DEPRDUR2=DEPRDUR2,
@REVALFLAG2=REVALFLAG2,
@REVDEPRFLAG2=REVDEPRFLAG2,
@PARTDEP2=PARTDEP2,
@APPROVED=APPROVED,
@UNITSETREF=UNITSETREF,
@QCCSETREF=QCCSETREF,
@DISTAMOUNT=DISTAMOUNT,
@CAPIBLOCK_CREATEDBY=CAPIBLOCK_CREATEDBY,
@CAPIBLOCK_CREADEDDATE=CAPIBLOCK_CREADEDDATE,
@CAPIBLOCK_CREATEDHOUR=CAPIBLOCK_CREATEDHOUR,
@CAPIBLOCK_CREATEDMIN=CAPIBLOCK_CREATEDMIN,
@CAPIBLOCK_CREATEDSEC=CAPIBLOCK_CREATEDSEC,
@CAPIBLOCK_MODIFIEDBY=CAPIBLOCK_MODIFIEDBY,
@CAPIBLOCK_MODIFIEDDATE=CAPIBLOCK_MODIFIEDDATE,
@CAPIBLOCK_MODIFIEDHOUR=CAPIBLOCK_MODIFIEDHOUR,
@CAPIBLOCK_MODIFIEDMIN=CAPIBLOCK_MODIFIEDMIN,
@CAPIBLOCK_MODIFIEDSEC=CAPIBLOCK_MODIFIEDSEC,
@SITEID=SITEID,
@RECSTATUS=RECSTATUS,
@ORGLOGICREF=ORGLOGICREF,
@UNIVID=UNIVID,
@DISTLOTUNITS=DISTLOTUNITS,
@COMBLOTUNITS=COMBLOTUNITS,
@WFSTATUS=WFSTATUS,
@DISTPOINT=DISTPOINT,
@CAMPPOINT=CAMPPOINT,
@CANUSEINTRNS=CANUSEINTRNS,
@ISONR=ISONR,
@GROUPNR=GROUPNR,
@PRODCOUNTRY=PRODCOUNTRY,
@ADDTAXREF=ADDTAXREF,
@QPRODAMNT=QPRODAMNT,
@QPRODUOM=QPRODUOM,
@QPRODSRCINDEX=QPRODSRCINDEX,
@EXTACCESSFLAGS=EXTACCESSFLAGS,
@PACKET=PACKET,
@SALVAGEVAL2=SALVAGEVAL2,
@SELLVAT=SELLVAT,
@RETURNVAT=RETURNVAT,
@LOGOID=LOGOID,
@LIDCONFIRMED=LIDCONFIRMED,
@GTIPCODE=GTIPCODE,
@EXPCTGNO=EXPCTGNO,
@B2CCODE=B2CCODE,
@MARKREF=MARKREF,
@IMAGE2INC=IMAGE2INC,
@AVRWHDURATION=AVRWHDURATION,
@EXTCARDFLAGS=EXTCARDFLAGS,
@MINORDAMOUNT=MINORDAMOUNT,
@FREIGHTPLACE=FREIGHTPLACE,
@FREIGHTTYPCODE1=FREIGHTTYPCODE1,
@FREIGHTTYPCODE2=FREIGHTTYPCODE2,
@FREIGHTTYPCODE3=FREIGHTTYPCODE3,
@FREIGHTTYPCODE4=FREIGHTTYPCODE4,
@FREIGHTTYPCODE5=FREIGHTTYPCODE5,
@FREIGHTTYPCODE6=FREIGHTTYPCODE6,
@FREIGHTTYPCODE7=FREIGHTTYPCODE7,
@FREIGHTTYPCODE8=FREIGHTTYPCODE8,
@FREIGHTTYPCODE9=FREIGHTTYPCODE9,
@FREIGHTTYPCODE10=FREIGHTTYPCODE10,
@STATECODE=STATECODE,
@STATENAME=STATENAME,
@EXPCATEGORY=EXPCATEGORY,
@LOSTFACTOR=LOSTFACTOR,
@TEXTINCENG=TEXTINCENG,
@EANBARCODE=EANBARCODE,
@DEPRCLASSTYPE=DEPRCLASSTYPE,
@WFLOWCRDREF=WFLOWCRDREF,
@SELLPRVAT=SELLPRVAT,
@RETURNPRVAT=RETURNPRVAT,
@LOWLEVELCODES1=LOWLEVELCODES1,
@LOWLEVELCODES2=LOWLEVELCODES2,
@LOWLEVELCODES3=LOWLEVELCODES3,
@LOWLEVELCODES4=LOWLEVELCODES4,
@LOWLEVELCODES5=LOWLEVELCODES5,
@LOWLEVELCODES6=LOWLEVELCODES6,
@LOWLEVELCODES7=LOWLEVELCODES7,
@LOWLEVELCODES8=LOWLEVELCODES8,
@LOWLEVELCODES9=LOWLEVELCODES9,
@LOWLEVELCODES10=LOWLEVELCODES10,
@ORGLOGOID=ORGLOGOID,
@QPRODDEPART=QPRODDEPART,
@CANCONFIGURE=CANCONFIGURE,
@CHARSETREF=CHARSETREF,
@CANDEDUCT=CANDEDUCT,
@CONSCODEREF=CONSCODEREF,
@SPECODE2=SPECODE2,
@SPECODE3=SPECODE3,
@SPECODE4=SPECODE4,
@SPECODE5=SPECODE5,
@EXPENSE=EXPENSE,
@ORIGIN=ORIGIN,
@NAME2=NAME2,
@COMPKDVUSE=COMPKDVUSE,
@USEDINPERIODS=USEDINPERIODS,
@EXIMTAX1=EXIMTAX1,
@EXIMTAX2=EXIMTAX2,
@EXIMTAX3=EXIMTAX3,
@EXIMTAX4=EXIMTAX4,
@EXIMTAX5=EXIMTAX5,
@PRODUCTLEVEL=PRODUCTLEVEL,
@APPSPEVATMATRAH=APPSPEVATMATRAH,
@NAME3=NAME3,
@FACOSTKEYS=FACOSTKEYS,
@KKLINESDISABLE=KKLINESDISABLE,
@APPROVE=APPROVE,
@APPROVEDATE=APPROVEDATE,
@GLOBALID=GLOBALID,
@SALEDEDUCTPART1=SALEDEDUCTPART1,
@SALEDEDUCTPART2=SALEDEDUCTPART2,
@PURCDEDUCTPART1=PURCDEDUCTPART1,
@PURCDEDUCTPART2=PURCDEDUCTPART2,
@CATEGORYID=CATEGORYID,
@CATEGORYNAME=CATEGORYNAME,
@KEYWORD1=KEYWORD1,
@KEYWORD2=KEYWORD2,
@KEYWORD3=KEYWORD3,
@KEYWORD4=KEYWORD4,
@KEYWORD5=KEYWORD5,
@GUID=GUID,
@DEMANDMEETSORTFLD1=DEMANDMEETSORTFLD1,
@DEMANDMEETSORTFLD2=DEMANDMEETSORTFLD2,
@DEMANDMEETSORTFLD3=DEMANDMEETSORTFLD3,
@DEMANDMEETSORTFLD4=DEMANDMEETSORTFLD4,
@DEMANDMEETSORTFLD5=DEMANDMEETSORTFLD5,
@DEDUCTCODE=DEDUCTCODE,
@PROJECTREF=PROJECTREF,
@NAME4=NAME4,
@QPRODSUBAMNT=QPRODSUBAMNT,
@QPRODSUBUOM=QPRODSUBUOM,
@QPRODSUBSRCINDEX=QPRODSUBSRCINDEX,
@QPRODSUBDEPART=QPRODSUBDEPART,
@PORDAMNTTOLERANCE=PORDAMNTTOLERANCE,
@SORDAMNTTOLERANCE=SORDAMNTTOLERANCE,
@MULTIADDTAX=MULTIADDTAX,
@CPACODE=CPACODE,
@PUBLICCOUNTRYREF=PUBLICCOUNTRYREF,
@FAUSEFULLIFECODE=FAUSEFULLIFECODE,
@FAUSEFULLIFECODE2=FAUSEFULLIFECODE2,
@MOLD=MOLD,
@MOLDLIFETRACKTYPE=MOLDLIFETRACKTYPE,
@MOLDUSAGELIFE=MOLDUSAGELIFE,
@MOLDFACTOR=MOLDFACTOR,
@MOLDMAINTNUMBER=MOLDMAINTNUMBER,
@MOLDMAINTLIFETYPE=MOLDMAINTLIFETYPE,
@MOLDMAINTLIFE=MOLDMAINTLIFE,
@MOLDLIFEASRATIO=MOLDLIFEASRATIO,
@MOLDMAINTTYPE=MOLDMAINTTYPE,
@MOLDMAINTBEGDATE=MOLDMAINTBEGDATE,
@MOLDMAINTPERIOD=MOLDMAINTPERIOD,
@MOLDMAINTPERUNIT=MOLDMAINTPERUNIT,
@OBTAINTYPE=OBTAINTYPE,
@GAINTYPE=GAINTYPE,
@FORECASTCODE=FORECASTCODE,
@SALESLIMITQUANTITY=SALESLIMITQUANTITY,
@NODISCOUNT=NODISCOUNT,
@LEVELCONTROL=LEVELCONTROL,
@NOTIFYCRDREF=NOTIFYCRDREF,
@UETDSUNCODE=UETDSUNCODE,
@UETDSUNDEF=UETDSUNDEF,
@UETDSLOADUNIT=UETDSLOADUNIT,
@UETDSTRANSPORTMODE=UETDSTRANSPORTMODE,
@UETDSTRANSPORTTYPE=UETDSTRANSPORTTYPE,
@UETDSLOADTYPE=UETDSLOADTYPE,
@UETDSLOADTYPEDEF=UETDSLOADTYPEDEF
FROM INSERTED
SET IDENTITY_INSERT LG_002_ITEMS ON
INSERT INTO LG_002_ITEMS
(
LOGICALREF,ACTIVE,CARDTYPE,CODE,NAME,STGRPCODE,PRODUCERCODE,SPECODE,CYPHCODE,CLASSTYPE,PURCHBRWS,SALESBRWS,MTRLBRWS,VAT,PAYMENTREF,TRACKTYPE,LOCTRACKING,TOOL,AUTOINCSL,DIVLOTSIZE,SHELFLIFE,
SHELFDATE,DOMINANTREFS1,DOMINANTREFS2,DOMINANTREFS3,DOMINANTREFS4,DOMINANTREFS5,DOMINANTREFS6,DOMINANTREFS7,DOMINANTREFS8,DOMINANTREFS9,DOMINANTREFS10,DOMINANTREFS11,DOMINANTREFS12,IMAGEINC,
TEXTINC,DEPRTYPE,DEPRRATE,DEPRDUR,SALVAGEVAL,REVALFLAG,REVDEPRFLAG,PARTDEP,DEPRTYPE2,DEPRRATE2,DEPRDUR2,REVALFLAG2,REVDEPRFLAG2,PARTDEP2,APPROVED,UNITSETREF,QCCSETREF,DISTAMOUNT,CAPIBLOCK_CREATEDBY,
CAPIBLOCK_CREADEDDATE,CAPIBLOCK_CREATEDHOUR,CAPIBLOCK_CREATEDMIN,CAPIBLOCK_CREATEDSEC,CAPIBLOCK_MODIFIEDBY,CAPIBLOCK_MODIFIEDDATE,CAPIBLOCK_MODIFIEDHOUR,CAPIBLOCK_MODIFIEDMIN,CAPIBLOCK_MODIFIEDSEC,
SITEID,RECSTATUS,ORGLOGICREF,UNIVID,DISTLOTUNITS,COMBLOTUNITS,WFSTATUS,DISTPOINT,CAMPPOINT,CANUSEINTRNS,ISONR,GROUPNR,PRODCOUNTRY,ADDTAXREF,QPRODAMNT,QPRODUOM,QPRODSRCINDEX,EXTACCESSFLAGS,PACKET,
SALVAGEVAL2,SELLVAT,RETURNVAT,LOGOID,LIDCONFIRMED,GTIPCODE,EXPCTGNO,B2CCODE,MARKREF,IMAGE2INC,AVRWHDURATION,EXTCARDFLAGS,MINORDAMOUNT,FREIGHTPLACE,FREIGHTTYPCODE1,FREIGHTTYPCODE2,FREIGHTTYPCODE3,
FREIGHTTYPCODE4,FREIGHTTYPCODE5,FREIGHTTYPCODE6,FREIGHTTYPCODE7,FREIGHTTYPCODE8,FREIGHTTYPCODE9,FREIGHTTYPCODE10,STATECODE,STATENAME,EXPCATEGORY,LOSTFACTOR,TEXTINCENG,EANBARCODE,DEPRCLASSTYPE,
WFLOWCRDREF,SELLPRVAT,RETURNPRVAT,LOWLEVELCODES1,LOWLEVELCODES2,LOWLEVELCODES3,LOWLEVELCODES4,LOWLEVELCODES5,LOWLEVELCODES6,LOWLEVELCODES7,LOWLEVELCODES8,LOWLEVELCODES9,LOWLEVELCODES10,ORGLOGOID,
QPRODDEPART,CANCONFIGURE,CHARSETREF,CANDEDUCT,CONSCODEREF,SPECODE2,SPECODE3,SPECODE4,SPECODE5,EXPENSE,ORIGIN,NAME2,COMPKDVUSE,USEDINPERIODS,EXIMTAX1,EXIMTAX2,EXIMTAX3,EXIMTAX4,EXIMTAX5,PRODUCTLEVEL,
APPSPEVATMATRAH,NAME3,FACOSTKEYS,KKLINESDISABLE,APPROVE,APPROVEDATE,GLOBALID,SALEDEDUCTPART1,SALEDEDUCTPART2,PURCDEDUCTPART1,PURCDEDUCTPART2,CATEGORYID,CATEGORYNAME,KEYWORD1,KEYWORD2,KEYWORD3,
KEYWORD4,KEYWORD5,GUID,DEMANDMEETSORTFLD1,DEMANDMEETSORTFLD2,DEMANDMEETSORTFLD3,DEMANDMEETSORTFLD4,DEMANDMEETSORTFLD5,DEDUCTCODE,PROJECTREF,NAME4,QPRODSUBAMNT,QPRODSUBUOM,QPRODSUBSRCINDEX,QPRODSUBDEPART,
PORDAMNTTOLERANCE,SORDAMNTTOLERANCE,MULTIADDTAX,CPACODE,PUBLICCOUNTRYREF,FAUSEFULLIFECODE,FAUSEFULLIFECODE2,MOLD,MOLDLIFETRACKTYPE,MOLDUSAGELIFE,MOLDFACTOR,MOLDMAINTNUMBER,MOLDMAINTLIFETYPE,
MOLDMAINTLIFE,MOLDLIFEASRATIO,MOLDMAINTTYPE,MOLDMAINTBEGDATE,MOLDMAINTPERIOD,MOLDMAINTPERUNIT,OBTAINTYPE,GAINTYPE,FORECASTCODE,SALESLIMITQUANTITY,NODISCOUNT,LEVELCONTROL,NOTIFYCRDREF,UETDSUNCODE,
UETDSUNDEF,UETDSLOADUNIT,UETDSTRANSPORTMODE,UETDSTRANSPORTTYPE,UETDSLOADTYPE,UETDSLOADTYPEDEF
)
VALUES
(
@LOGICALREF,@ACTIVE,@CARDTYPE,@CODE,@NAME,@STGRPCODE,@PRODUCERCODE,@SPECODE,@CYPHCODE,@CLASSTYPE,@PURCHBRWS,@SALESBRWS,@MTRLBRWS,@VAT,@PAYMENTREF,@TRACKTYPE,@LOCTRACKING,@TOOL,@AUTOINCSL,@DIVLOTSIZE,
@SHELFLIFE,@SHELFDATE,@DOMINANTREFS1,@DOMINANTREFS2,@DOMINANTREFS3,@DOMINANTREFS4,@DOMINANTREFS5,@DOMINANTREFS6,@DOMINANTREFS7,@DOMINANTREFS8,@DOMINANTREFS9,@DOMINANTREFS10,@DOMINANTREFS11,@DOMINANTREFS12,
@IMAGEINC,@TEXTINC,@DEPRTYPE,@DEPRRATE,@DEPRDUR,@SALVAGEVAL,@REVALFLAG,@REVDEPRFLAG,@PARTDEP,@DEPRTYPE2,@DEPRRATE2,@DEPRDUR2,@REVALFLAG2,@REVDEPRFLAG2,@PARTDEP2,@APPROVED,@UNITSETREF,@QCCSETREF,@DISTAMOUNT,
@CAPIBLOCK_CREATEDBY,@CAPIBLOCK_CREADEDDATE,@CAPIBLOCK_CREATEDHOUR,@CAPIBLOCK_CREATEDMIN,@CAPIBLOCK_CREATEDSEC,@CAPIBLOCK_MODIFIEDBY,@CAPIBLOCK_MODIFIEDDATE,@CAPIBLOCK_MODIFIEDHOUR,@CAPIBLOCK_MODIFIEDMIN,
@CAPIBLOCK_MODIFIEDSEC,@SITEID,@RECSTATUS,@ORGLOGICREF,@UNIVID,@DISTLOTUNITS,@COMBLOTUNITS,@WFSTATUS,@DISTPOINT,@CAMPPOINT,@CANUSEINTRNS,@ISONR,@GROUPNR,@PRODCOUNTRY,@ADDTAXREF,@QPRODAMNT,@QPRODUOM,
@QPRODSRCINDEX,@EXTACCESSFLAGS,@PACKET,@SALVAGEVAL2,@SELLVAT,@RETURNVAT,@LOGOID,@LIDCONFIRMED,@GTIPCODE,@EXPCTGNO,@B2CCODE,@MARKREF,@IMAGE2INC,@AVRWHDURATION,@EXTCARDFLAGS,@MINORDAMOUNT,@FREIGHTPLACE,
@FREIGHTTYPCODE1,@FREIGHTTYPCODE2,@FREIGHTTYPCODE3,@FREIGHTTYPCODE4,@FREIGHTTYPCODE5,@FREIGHTTYPCODE6,@FREIGHTTYPCODE7,@FREIGHTTYPCODE8,@FREIGHTTYPCODE9,@FREIGHTTYPCODE10,@STATECODE,@STATENAME,
@EXPCATEGORY,@LOSTFACTOR,@TEXTINCENG,@EANBARCODE,@DEPRCLASSTYPE,@WFLOWCRDREF,@SELLPRVAT,@RETURNPRVAT,@LOWLEVELCODES1,@LOWLEVELCODES2,@LOWLEVELCODES3,@LOWLEVELCODES4,@LOWLEVELCODES5,@LOWLEVELCODES6,
@LOWLEVELCODES7,@LOWLEVELCODES8,@LOWLEVELCODES9,@LOWLEVELCODES10,@ORGLOGOID,@QPRODDEPART,@CANCONFIGURE,@CHARSETREF,@CANDEDUCT,@CONSCODEREF,@SPECODE2,@SPECODE3,@SPECODE4,@SPECODE5,@EXPENSE,@ORIGIN,
@NAME2,@COMPKDVUSE,@USEDINPERIODS,@EXIMTAX1,@EXIMTAX2,@EXIMTAX3,@EXIMTAX4,@EXIMTAX5,@PRODUCTLEVEL,@APPSPEVATMATRAH,@NAME3,@FACOSTKEYS,@KKLINESDISABLE,@APPROVE,@APPROVEDATE,@GLOBALID,@SALEDEDUCTPART1,
@SALEDEDUCTPART2,@PURCDEDUCTPART1,@PURCDEDUCTPART2,@CATEGORYID,@CATEGORYNAME,@KEYWORD1,@KEYWORD2,@KEYWORD3,@KEYWORD4,@KEYWORD5,@GUID,@DEMANDMEETSORTFLD1,@DEMANDMEETSORTFLD2,@DEMANDMEETSORTFLD3,
@DEMANDMEETSORTFLD4,@DEMANDMEETSORTFLD5,@DEDUCTCODE,@PROJECTREF,@NAME4,@QPRODSUBAMNT,@QPRODSUBUOM,@QPRODSUBSRCINDEX,@QPRODSUBDEPART,@PORDAMNTTOLERANCE,@SORDAMNTTOLERANCE,@MULTIADDTAX,@CPACODE,
@PUBLICCOUNTRYREF,@FAUSEFULLIFECODE,@FAUSEFULLIFECODE2,@MOLD,@MOLDLIFETRACKTYPE,@MOLDUSAGELIFE,@MOLDFACTOR,@MOLDMAINTNUMBER,@MOLDMAINTLIFETYPE,@MOLDMAINTLIFE,@MOLDLIFEASRATIO,@MOLDMAINTTYPE,
@MOLDMAINTBEGDATE,@MOLDMAINTPERIOD,@MOLDMAINTPERUNIT,@OBTAINTYPE,@GAINTYPE,@FORECASTCODE,@SALESLIMITQUANTITY,@NODISCOUNT,@LEVELCONTROL,@NOTIFYCRDREF,@UETDSUNCODE,@UETDSUNDEF,@UETDSLOADUNIT,
@UETDSTRANSPORTMODE,@UETDSTRANSPORTTYPE,@UETDSLOADTYPE,@UETDSLOADTYPEDEF
)
SET IDENTITY_INSERT LG_002_ITEMS OFF
END
Hocam bu kodla sorun yaşamıyorum. Ama Çok uzun değil mi?