@echo off & setlocal EnableDelayedExpansion
set count=0
for /f "tokens=1,2* delims=." %%a in (not_in_final.lst) do set /a COUNT+=1 & echo insert into myschema.tablename values ('!COUNT!', '%%a', '%%b');>>insert.sql
pause
注意引用的时候要用“!count!”,而不是%count%或者%count