Home Articles Details
Call ErnesTech Today +1 888-688-2939 +1 888-688-2939   Custom Software Development at ErnesTech Email Address [email protected]  
.Net 7 189 AI 114 Technology 105 Other 86 SQL 58 Servers 52 Research 45 Questions 35 Jobs 35 Databases 35 Entity Framework 29 Programming 27 Docker 26 Linux 25 Network 20 Machine Learning 19 Android 19 Home 16 C-Sharp 13 Art 12 Windows 12 JavaScript 11 Lipedema 9 System Design 8 HTML5 8 Candles 8 Docker Compose 7 Tutorials 7 MVC 7 Tools 6 Algorithms 6 General 6 Hardware 6 .NET 5 5 Bootstrap 5 G 4 Health 2 Voip 1 Self-Help 1

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 do you get an ID of recording getting inserted
How to Connect to Linux Ubuntu 20 using Remote Des
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

Login to Continue, We will bring you back to this content 0

© 2025 - 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]  
For peering opportunity Autonomouse System Number: AS401345 Custom Software Development at ErnesTech Email Address[email protected]