Before we get into the examples, it is important to remember that
sqlcmd can be run in several different ways. It can be run interactively from the command prompt, from a batch file, or from a Query Editor window in SSMS. When run interactively, the
sqlcmd program name is entered at the command prompt followed by the required options to connect to the database server. When the connection is established, a numbered row is presented, after which you enter your T-SQL commands. Multiple rows of T-SQL can be entered in a batch; they are executed only after the
GO command has been entered. Figure 4.1 shows an example of a simple
SELECT statement that was executed interactively with
sqlcmd. The connection in this example ...