SQLCMD
SQLCMD.exe called from a batch file or command line
Section titled “SQLCMD.exe called from a batch file or command line”echo off
cls
sqlcmd.exe -S "your server name" -U "sql user name" -P "sql password" -d "name of databse" -Q "here you may write your query/stored procedure"Batch files like these can be used to automate tasks, for example to make backups of databases at a specified time (can be scheduled with Task Scheduler) for a SQL Server Express version where Agent Jobs can’t be used.
Remarks
Section titled “Remarks”You either need to be in the path where SQLCMD.exe exists or add it to your PATH environment variable.