Click here to Skip to main content
Click here to Skip to main content
Search within:



 
Comments & Discussions (2)

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

By , 3 Feb 2012
 
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)

About the Author

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

Article Top
 
Sign Up to vote   Poor Excellent
Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Comments and Discussions

 
You must Sign In to use this message board.
Search this forum  
    Spacing  Noise  Layout  Per page   
First Prev Next
Generalwe may have morethan one database, within that so many table... Pinmemberrajigopalan7 Feb '12 - 21:22 2 
Last Visit: 31 Dec '99 - 18:00     Last Update: 25 May '13 - 18:15Refresh1

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

About Article
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...
Type Tip/Trick
Licence CPOL
First Posted 3 Feb 2012
Views 1,925
Bookmarked 0 times
Top News

Old Japanese Man Creates Amazing Art Using Excel (Wait, Excel?)

Get the Insider News free each morning.
Related Videos
Entity Framework: Querying with Entity SQL Part 1
Entity Framework: Querying with Entity SQL Part 2
How to trace SQL Server Express without using SQL Profiler
Execute SQL Query / SQL Command on SQL Server Using the Command Prompt
SQL SERVER - 2005 - Introduction and Explanation to sqlcmd
SQL Server DO's and DONT's
An Interactive SQL Console
Intercepting .NET SQL queries at runtime
SqlDoc: Document your SQL Server database
Getting started with SQL Server Everywhere
Moving SQL Server 2005 Databases to SQL Server 2000
A Beginner's Tutorial for Understanding ADO.NET
Dynamic Management Views [DMV] – A SQL Server 2005 Feature
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard
Get Top X rows from a table
SSMSKeyBindings - edit keybindings in sql mgt studio
SQL Server Transactions and Error Handling
Building Dynamic SQL In a Stored Procedure
HowTo: Install the Northwind and Pubs Sample Databases in SQL Server 2008 Express
How to Integrate an OLE Object with SQL Server
Database Security Testing In the Light of SQL Injection Attack
Paging and Sorting on SQL Server and Oracle using Sql.Net
Permalink | Advertise | Privacy | Mobile
Web01 | 2.6.130523.1 | Last Updated 3 Feb 2012
Article Copyright 2012 by manish76235
Everything else Copyright © CodeProject, 1999-2013
Terms of Use
Layout: fixed | fluid