How to use xp_cmdshell to execute multi-line CMD commands

Because an external program needs to be called with SQL script, try the xp_cmdshell command and find that it only executes one line of commands by default, and finally finds the following method:

The multi-line cmd command is processed into a bat file, which is then directly executed using the path + file:

such as the following Hiapk.bat file:

CD C:\Users\Administrator\Desktop\wandoujia
Python anzhi.py

Call with SQL script:

EXEC Master. xp_cmdshell ' C:\Users\Administrator\Desktop\wandoujia\hiapk.bat '

How to use xp_cmdshell to execute multi-line CMD commands