SQLCMD In SQL

The most important option that you need to know about SQLCMD are as follows:-

Note:- SQLCMD options are case-sensitive.

·       -S <sql_server_name>:-  the name of the SQL Server, including instance, if applicable. You may use "." (without quotes) if you are running SQLCMD on the same machine as SQL Server.

·       -d <database_name>:-  the name of the database on which the operation is to be performed. For example -d Test.

·       -U <user_name>:-  the SQL Server user account under which to run the specified command.

·       -P <password>:- the password associated with the specified user account.

·       -E :- use NT authentication to interact with SQL Server

·       -Q "<SQL-command>":- the command to issue to SQL Server.

·       -i <file_of_SQL_commands>:-  a file containing one or more commands to issue to SQL Server.

SQLCMD can also operate interactively. If you specify only the server, database, user name, and password, you will be presented with a prompt allowing you to enter and execute commands one at a time. The command "exit" exists interactive mode.

For more information about other options, you can type "SQLCMD -?" for help.