sql serversql-server-2008sqlcmd
If I remember correctly, last time Microsoft Sqlcmd require each command to end with ';' and hit Enter key to execute the command.
However, currently, we need to type the GO each time to execute the command.
So, are there other alternative such that when we hit Enter key after ending the command with ';', it will Execute the command?
Have you considered SQLCMD?
Here's an article on Using the SQLCMD command line utility.
You can execute adhoc SQL statements, or run .sql scripts.
The following example runs the C:\MyScript.sql script from the command line and outputs the queries and results to a text file located at C:\MyResults.txt.
C:\Windows>sqlcmd -S NOTTINTRA3\SQL2005 -i C:\MyScript.sql -o c:\MyResults.txt -e
Why are you using a batch file to backup the databases? Why not put the code in a SQL Agent job and have that kick off the backup?
Best Answer
No, you need to type a batch separator. The default is
GO. However, you can change that by using the-cswitch.For example:
C:\>sqlcmd -SServername -cFOO1> select @@versionhit enter
2> FOOhit enter
This will run.
Can't get rid of the intermediate enter for you. Sorry.