I was given a huge batch file(windows) which when I run it generates the following error:
VALUES was unexpected at this time.
I manage to remove a great part of it and break it down to the following code(read a text file and insert data to a sql server table:
<code>@echo off
setlocal enabledelayedexpansion
set "input_file=data.txt"
set "server=166.444.44.44"
set "database=MYDB"
set "table=Test"
set "sql_file=insert_data.sql"
rem Delete old SQL file if it exists
if exist %sql_file% del %sql_file%
rem Read the input file and generate insert statements
for /f "tokens=1,2,3,4 delims=, eol=;" %%A in (%input_file%) do (
echo INSERT INTO %table% (Name, Age, Income, Address) VALUES ('%%A', %%B, %%C, '%%D'); >> %sql_file%
)
rem Execute the SQL file using sqlcmd
sqlcmd -S %server% -d %database% -E -i %sql_file%
rem Cleanup
del %sql_file%
endlocal
</code>
<code>@echo off
setlocal enabledelayedexpansion
set "input_file=data.txt"
set "server=166.444.44.44"
set "database=MYDB"
set "table=Test"
set "sql_file=insert_data.sql"
rem Delete old SQL file if it exists
if exist %sql_file% del %sql_file%
rem Read the input file and generate insert statements
for /f "tokens=1,2,3,4 delims=, eol=;" %%A in (%input_file%) do (
echo INSERT INTO %table% (Name, Age, Income, Address) VALUES ('%%A', %%B, %%C, '%%D'); >> %sql_file%
)
rem Execute the SQL file using sqlcmd
sqlcmd -S %server% -d %database% -E -i %sql_file%
rem Cleanup
del %sql_file%
endlocal
</code>
@echo off
setlocal enabledelayedexpansion
set "input_file=data.txt"
set "server=166.444.44.44"
set "database=MYDB"
set "table=Test"
set "sql_file=insert_data.sql"
rem Delete old SQL file if it exists
if exist %sql_file% del %sql_file%
rem Read the input file and generate insert statements
for /f "tokens=1,2,3,4 delims=, eol=;" %%A in (%input_file%) do (
echo INSERT INTO %table% (Name, Age, Income, Address) VALUES ('%%A', %%B, %%C, '%%D'); >> %sql_file%
)
rem Execute the SQL file using sqlcmd
sqlcmd -S %server% -d %database% -E -i %sql_file%
rem Cleanup
del %sql_file%
endlocal
Even with this I’m getting ” VALUES was unexpected at this time.”
I did a lot of research but so far no luck.