InsertArt SQL begin transaction;IF NOT EXISTS (Select 1 from art where art_ref='8435606728249') INSERT INTO art (ART_REF, ART_CBP, ART_COD, ART_DCR, ART_FAM, ART_SFA, ART_IVA, ART_IVAC, ART_VEN, ART_SEC, DTALT, ART_CRI, Estado, ART_ABT, ART_DC1,ART_DC2,ART_UNI,ART_FOT,ART_CST,ART_IMP,ART_CSF,ART_MED,ART_PCU,ART_ETI,ART_COLN,ART_PGN,ART_PRMINI,ART_PRMFIN,ART_DSCPRM,ART_DIP,ART_DFP,ART_MAX,ART_MIN,ART_IDE, ART_TIP,ART_OBS,ART_MEM,ART_DS1,ART_DS2,ART_DS3,ART_DS4,ART_MRV,ART_KMT,ART_BLK,ART_PES,ART_PPP,ART_COO,ART_COV,ART_UPP,ART_PCI,ART_STK,ART_WEB,ART_TAR,ART_PA1,ART_PA2, ART_UET,ART_TCH,ART_DCT,ART_SEL,ART_NSE,ART_MRI,ART_LIS,ART_PMT,PROMO,LEVE,PAGUE,ART_LOC,ART_PNT,ART_STC,ART_BLP,ART_EBI,ART_EMB,ART_CON,ART_BME,ART_SIT,ART_FOR,ART_ET2, ART_CNT,ART_CN2  ,ART_QUE  ,ART_ENC,ART_PDA  ,ART_RCP  ,ART_TAX  ,ART_VID  ,ART_ARM  ,ART_PRC  ,ART_LOT  ,ART_FIV  ,ART_COM  ,ART_PDR  ,ART_ETP  ,ART_DED  ,ART_PEP  ,ART_CN3, ART_CN4  ,ART_CN5  ,ART_CN6  ,ART_CN7  ,ART_EPD  ,ART_GRP  ,ART_PET  ,ART_ETE  ,ART_REP  ,ART_UNM  ,ART_TEB  ,ART_ORI  ,ART_VSC  ,ART_ALT  ,ART_LAR  ,ART_PSO  ,ART_CUB,ART_CN8, ART_INT,ART_ROT,ART_COMQ,ART_COMV,ART_QIN,ART_MAC,ART_SHO,ART_QNT,ART_LOJ  ,ART_VAL,ART_LOM,ART_QNTV,ART_DES,ART_REC,ART_DTI,art_mar,art_quebra,art_vendq, art_lota,ART_IVAf,ART_JUN,ART_MOT,stk_vis,vnd_loj,ART_COR2,ART_DPDA,ART_RAP,Alterado,art_ufor,art_RFO,art_puc,art_doc,art_msg,custonet,contrato,acordado, cusnetnet,margemapl,contratonc,art_dc3,art_mem1,art_mem2,art_mem3,art_obs1,art_obs2,art_obs3,ART_ENT,ART_OUT,loja,movimentado,foto1,foto2,auchan,contin,art_cmr,art_mes,art_me2,art_tbp,art_pro)VALUES('8435606728249','8435606728249',0,'B6110 BL Cable de datos S.Basic Flute para Type C, 1M, 3.4A, Blanco', ,1.000,3,3,3.95,0,GETDATE(), cast(GETDATE() as date), 9,  '', '', '', 0, '', 0, 0, 0, 0, 0, 0, 0, 0, '1900-01-01', '1900-01-01', 0, '1900-01-01', '1900-01-01', 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, '1900-01-01', 0, '', 0,0,0,0, 0, 0,0,0,'', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,'1900-01-01', 0, 0, 0,'', '','', '', '',0,0,0,0,0,0,0, 0, 0,0,0,0,0, 0 , '',0, 0,0,0,0, 0,'','1900-01-01',0, 0, '1900-01-01', 0, '1900-01-01', 0, 0,0, '',0, '', '',0,0, 0, 0,0, 0, 0, '',0, '', '', 0,'', 0,0,0,'', '','','','','','','',0,0, 0,0,0,0, 0, 0,0,0,0, '',0)else UPDATE art SET art_dcr='B6110 BL Cable de datos S.Basic Flute para Type C, 1M, 3.4A, Blanco', art_ven=3.95, art_fam=, art_sfa=1.000, art_sec=0,Estado=9, art_iva=3, art_ivac=3 WHERE art_ref='8435606728249'; IF NOT EXISTS (Select 1 from prc where prc_chv=cast('8435606728249' as char(15))+str(0,2)+str(0,2))INSERT INTO prc(PRC_LIN,PRC_PRC,PRC_LOJ,ART_REF,ESTADO,ART_UAP,PRC_UTL,PRC_OND,PRC_ANT,PRC_IVA,PRC_DIP,PRC_DFP,PRC_PPP,PRC_PEP,PRC_CHV,loja)VALUES(0,3.95,0,'8435606728249',9,GETDATE(),1,-1,0,0,'1900-01-01','1900-01-01',0,0,cast('8435606728249' as char(15))+str(0,2)+str(0,2),1)else UPDATE prc SET PRC_LIN = 0, PRC_PRC=3.95, PRC_LOJ=0,ART_REF='8435606728249', ESTADO=9, ART_UAP=GETDATE(), PRC_UTL=1, PRC_OND=-1, PRC_ANT=0, PRC_IVA=0, PRC_DIP='1900-01-01', PRC_DFP='1900-01-01', PRC_PPP=0, PRC_PEP=0,PRC_CHV=cast('8435606728249' as char(15))+str(0,2)+str(0,2), loja=1 WHERE ART_REF='8435606728249'; IF NOT EXISTS (Select 1 from cba where art_cba='8435606728249') INSERT INTO cba(ART_CBA, ART_REF, ART_QPE, ESTADO, CBA_VEN, CBA_FAC, CBA_DCR, CBA_DPDA, dtalt, loja)VALUES('8435606728249', '8435606728249', 1, 9, 0, 1, '', 0, GETDATE(),1) else update cba set art_ref='8435606728249' where art_cba='8435606728249';commit; : Incorrect syntax near ','.