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:
- 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.
FeedbackTechnology
397
.Net 5
26
Questions
22
Docker
15
Jobs
10
.Net 6
9
Machine-Learning
8
Education
4
Research
4
Software Development
4
IOT
2
Entity Framework
2
Art
2
Programming Music
2
Git
2
Hardware
2
Health
1
Home
1
Home Emprovements
1
Project
1
Question
1
C-Sharp
1
Chrome
1
Algorithms
1
Front-End
1
JavaScript
1
Server
1
Tools
1
Writing
1
XML
1
SQL
1
System Design
1
Login With Your Email
Sign Up For Free Account
