Home Articles Details
Call ErnesTech Today +1 888-688-2939 +1 888-688-2939   Custom Software Development at ErnesTech Email Address [email protected]  

Connect to Database Using CMD


Sometimes it serves a lot of time to just connect to the database using the command prompt, its easy, reliable and fast.
In this section, I will outline how to connect to an instance of SQL server and get access to databases on your local machine:
  1. Open up a command prompt
  2. type: sqlcmd
  3. On the same line, type: -S(ServerName\SqlInstanceName)
  4. Then you can query: Select * from sys.databases
  5. On the next line: Type Go
  6. If successfully connected, all the databases will display
  7. Then go ahead and choose which database to use by typing:
  8. Use "your database"
  9. On the next line:
  10. If you are using T-sql just to show the tables in that database just type:
  11. sp_tables "DatabaseName" (without quotation marks)
  12. On the next line, type 'Go' and enter
  13. All the tables should display then use the tables you want to query the data. Have fun.
#Technology
Databases
published
v.0.01


How to Connect to Linux Ubuntu 20 using Remote Des
How do you get an ID of recording getting inserted
How to Connect to Azure Lunux Virtual Machine Usin
How to Connect to PostgreSQL using ODBC 32bit Dsn
How to Code a Windows Service that Updates the Dat
How to Transfer Database from Sql Server 2012 to S
ERROR 2002 (HY000): Can't connect to local MySQL s
Use A Network Attached Drive To Develop An App
Enable Administrator Acc On Windows 10
[Call API in Java] documentation about calling api
Mysql Connect to Remote Server
Asp.Net 5 Development Notes (DotNet Core 3.1 Study
Asp.Net Core 3.1 Entity Framwork Database Context
Error 0xc02020a1: Data Flow Task 1: Data conversio
© 2024 - ErnesTech - Privacy
E-Commerce Return Policy
Call ErnesTech Today +1 (216)-435-0788 +1 (216)-435-0788   Custom Software Development at ErnesTech Email Address [email protected]