如何实现sql脚本文件的操作？

Question

有一个脚本文件。内容就是：
DELETE FROM YNFY where HTH='06240302010018';
INSERT INTO YNFY(HTH,GZHF,NJF,GZNY,YM,KYMSL,KYMJE,DJ,DCSL,DCJE,ZDMJ,ZDJE,GQJE,ZFYSL,WLYSL,WLYJE,QQBT,N1,N2,N3,N4,N5,N6,N7,N8,FYYear,SENDNO) Values('06240302010018',0,0,0,0,0,0,,0,0,0,0,0,0,88,9999,'0',0,,,,,,,,'2005','0');
DELETE FROM YNFY where HTH='06240301030019';
INSERT INTO YNFY(HTH,GZHF,NJF,GZNY,YM,KYMSL,KYMJE,DJ,DCSL,DCJE,ZDMJ,ZDJE,GQJE,ZFYSL,WLYSL,WLYJE,QQBT,N1,N2,N3,N4,N5,N6,N7,N8,FYYear,SENDNO) Values('06240301030019',0,0,0,0,0,0,,0,0,0,0,0,0,55,555,'0',0,,,,,,,,'2005','0');
DELETE FROM YNFY where HTH='06240301010005';
INSERT INTO YNFY(HTH,GZHF,NJF,GZNY,YM,KYMSL,KYMJE,DJ,DCSL,DCJE,ZDMJ,ZDJE,GQJE,ZFYSL,WLYSL,WLYJE,QQBT,N1,N2,N3,N4,N5,N6,N7,N8,FYYear,SENDNO) Values('06240301010005',0,0,0,0,0,0,,0,0,0,0,0,0,0,0,'11111',0,,,,,,,,'2005','0');......
我想在程序里，控制这个脚本，能让它执行，把数据导入到sql server里，怎么做呢？

Answer 1

用isql命令执行就可以了，假如说你的sql文件是test.sql
执行命令“isql -U sa -P -S zk -d tempdb -i "E:\zk\test.sql"”就可以

Answer 2

用ADOQuery加载这个Sql文件内容，也可以执行