Subject executescript
From Osvaldo Ramirez
Date Fri, 13 Jul 2018 15:58:35 -0600
Newsgroups sqlexpress

Dear Boris

I have some question regards executescript()

1.- Is there a max of commands  or lines inside of the script ?
( I have one Txt with 9000 lines )

2.- The script is execute on the server side, but Is it executed line by
line ? or it is execute the whole script ?, Do I need add some parameter
to execute in one way or another  ?


3.- What is the correct form of an script text ?

The follow script is correct ?

INSERT INTO existen(existencia,fecha,hora,barcode,suc_id)
values(8,'20180713','15:49:51','7501537184711  ',050) ON DUPLICATE KEY
UPDATE  existencia=8, fecha= '20180713', hora= '15:49:51';
INSERT INTO existen(existencia,fecha,hora,barcode,suc_id)
values(0,'20180713','15:49:51','785118753528   ',050) ON DUPLICATE KEY
UPDATE  existencia=0, fecha= '20180713', hora= '15:49:51';
INSERT INTO existen(existencia,fecha,hora,barcode,suc_id)
values(0,'20180713','15:49:51','785118753597   ',050) ON DUPLICATE KEY
UPDATE  existencia=0, fecha= '20180713', hora= '15:49:51';
INSERT INTO existen(existencia,fecha,hora,barcode,suc_id)
values(0,'20180713','15:49:51','7501825300595  ',050) ON DUPLICATE KEY
UPDATE  existencia=0, fecha= '20180713', hora= '15:49:51';
INSERT INTO existen(existencia,fecha,hora,barcode,suc_id)
values(0,'20180713','15:49:51','75017125       ',050) ON DUPLICATE KEY
UPDATE  existencia=0, fecha= '20180713', hora= '15:49:51';
INSERT INTO existen(existencia,fecha,hora,barcode,suc_id)
values(0,'20180713','15:49:51','7501075713718  ',050) ON DUPLICATE KEY
UPDATE  existencia=0, fecha= '20180713', hora= '15:49:51';
GO

Thanks in advance

Osvado Ramirez

Recent messages in this thread
 
-# executescript (Current message) Osvaldo Ramirez 13-Jul-2018 10:58 pm
.\# Re: executescript Boris Borzic <bb> 14-Jul-2018 12:55 pm