InsertArt SQL begin transaction;IF NOT EXISTS (Select 1 from art where art_ref='') 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('','',0,'', 1,1.000,3,3,,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='', art_ven=, art_fam=1, art_sfa=1.000, art_sec=0,Estado=9, art_iva=3, art_ivac=3 WHERE art_ref=''; IF NOT EXISTS (Select 1 from prc where prc_chv=cast('' 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,,0,'',9,GETDATE(),4,-1,0,0,'1900-01-01','1900-01-01',0,0,cast('' as char(15))+str(0,2)+str(0,2),1)else UPDATE prc SET PRC_LIN = 0, PRC_PRC=, PRC_LOJ=0,ART_REF='', ESTADO=9, ART_UAP=GETDATE(), PRC_UTL=4, PRC_OND=-1, PRC_ANT=0, PRC_DIP='1900-01-01', PRC_DFP='1900-01-01', PRC_PEP=0,PRC_CHV=cast('' as char(15))+str(0,2)+str(0,2), loja=1 WHERE ART_REF=''; IF NOT EXISTS (Select 1 from cba where art_cba='') INSERT INTO cba(ART_CBA, ART_REF, ART_QPE, ESTADO, CBA_VEN, CBA_FAC, CBA_DCR, CBA_DPDA, dtalt, loja)VALUES('', '', 1, 9, 0, 1, '', 0, GETDATE(),1) else update cba set art_ref='' where art_cba='';commit; : Incorrect syntax near ','.