407
Technology
26
.Net 5
23
.NET 6
23
Questions
15
Docker
12
Jobs
8
Machine-Learning
4
Education
4
Research
4
Software Development
3
Entity Framework
2
Art
2
Programming Music
2
General
2
Git
2
Hardware
2
IOT
1
JavaScript
1
Server
1
Tools
1
Writing
1
XML
1
SQL
1
System Design
1
Health
1
Home
1
Home Emprovements
1
Question
1
C-Sharp
1
Chrome
1
Algorithms
1
Front-End
Connect to Database Using CMD
Join the Community
Sometimes it serves a lot of time to just connect to the database using the command prompt, its easy, reliable and fast.
Edit this Article
In this section, I will outline how to connect to an instance of SQL server and get access to databases on your local machine:
- Open up a command prompt
- type: sqlcmd
- On the same line, type: -S(ServerName\SqlInstanceName)
- Then you can query: Select * from sys.databases
- On the next line: Type Go
- If successfully connected, all the databases will display
- Then go ahead and choose which database to use by typing:
- Use "your database"
- On the next line:
- If you are using T-sql just to show the tables in that database just type:
- sp_tables "DatabaseName" (without quotation marks)
- On the next line, type 'Go' and enter
- All the tables should display then use the tables you want to query the data. Have fun.
Edit this Article
Feedback