Click here to Skip to main content
Click here to Skip to main content
Alternative Tip/Trick

Tagged as

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

, 3 Feb 2012 CPOL
Rate this:
Please Sign up or sign in to vote.
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...
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 will execute the query and show the result on the screen.
 
This can be used when there is no SSMS available and just need to check any tables or execute any queries for maintenance.

License

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

Share

About the Author

manish76235
Architect Safaltek Software
India India
Working for over 20 years now and still learning.
Working for a product base company building solutions for the marine world.

Comments and Discussions

 
Generalwe may have morethan one database, within that so many table... Pinmemberrajigopalan7-Feb-12 21:22 
we may have morethan one database, within that so many table. where to mention the both
GeneralRe: on script.sql, you may to use different database, as long as... PinmemberIkhwanKrisnadi12-Feb-12 17:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web01 | 2.8.141022.2 | Last Updated 3 Feb 2012
Article Copyright 2012 by manish76235
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid