Click here to Skip to main content
15,885,651 members
Articles / Database Development / SQL Server / SQL Server 2008

Execute SQL Query / SQL Command on SQL Server Using the Command Prompt

Rate me:
Please Sign up or sign in to vote.
5.00/5 (2 votes)
25 Jan 2012CPOL 73.3K   3  
How to execute SQL Query / SQL Command on SQL Server using command prompt.

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

Please Sign up or sign in to vote.
3 Feb 2012manish76235
SQLCMD can be used to login to the Sql Server as well. One can only provide Server address, User Name and Password at the command prompt and press enter.The command prompt will change to 1>. Now any sql query can typed and by pressing enter in the next prompt a GO command and pressing enter...

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Indonesia Indonesia
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions