批处理文件中这样写应该就可以了,注意不要换行isql -S ngc -U czdszm -P czdszm110 -Q"Declare @ls_curdate varchar(10) select @ls_curdate= CONVERT(varchar (10),GETDATE(),112) exec p_zj_licence_in @ls_curdate,@ls_curdate exec p_zj_licence_update "
调试欢乐多
文件autoexecsql.bat的内容如下:
isql -S ngc -U czdszm -P czdszm110 -i autoexecsql.txt文件autoexecsql.txt内容如下:
Declare @ls_curdate varchar(10)
select @ls_curdate= CONVERT(varchar (10),GETDATE(),112)
exec p_zj_licence_in @ls_curdate,@ls_curdate
exec p_zj_licence_update
GO记住一定这两个文件要放一起