Ernes
Tech
Register
Login
AI
Search
News
Articles
Videos
1
Home
Articles
Details
+1 888-688-2939
[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:
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.
#Technology
Databases
published
v.0.01
Notify Me of New Posts
×
We Recieved Your Request. Thank you.
We'll never share your email with anyone else.
Submit
You Liked This Article
Post Comment
How do you get an ID of recording getting inserted
How do you get an ID of recording getting inserted in sql
SQL
Read Article
How to Connect to Linux Ubuntu 20 using Remote Des
How to Connect to Linux Ubuntu 20 using Remote Desktop from Windows
LUNUX
Read Article
How to Connect to Azure Lunux Virtual Machine Usin
How to Connect to Azure Lunux Virtual Machine Using SSH Private Key in Putty
SERVERS
Read Article
How to Connect to PostgreSQL using ODBC 32bit Dsn
How to Connect to PostgreSQL using ODBC 32bit Dsn and Connection String from SQL Server
SQL
Read Article
How to Code a Windows Service that Updates the Dat
How to Code a Windows Service that Updates the Database Table Nightly
.NET 7
Read Article
How to Transfer Database from Sql Server 2012 to S
How to Transfer Database from Sql Server 2012 to Sql Server 2017
SQL
Read Article
ERROR 2002 (HY000): Can't connect to local MySQL s
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
SQL
Read Article
Use A Network Attached Drive To Develop An App
Use A Network Attached Drive To Develop An App
NETWORK
Read Article
Enable Administrator Acc On Windows 10
Enable Administrator Acc On Windows 10
WINDOWS
Read Article
[Call API in Java] documentation about calling api
[Call API in Java] documentation about calling api in java
TECHNOLOGY
Read Article
Mysql Connect to Remote Server
Mysql Connect to Remote Server
SQL
Read Article
Asp.Net 5 Development Notes (DotNet Core 3.1 Study
Asp.Net 5 Development Notes (DotNet Core 3.1 Study Notes)
SOFTWARE DEVELOPMENT
Read Article
Asp.Net Core 3.1 Entity Framwork Database Context
Asp.Net Core 3.1 Entity Framwork Database Context Error: System.ObjectDisposedException: 'Cannot access a disposed object
.NET 7
Read Article
Error 0xc02020a1: Data Flow Task 1: Data conversio
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "NAME" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". (SQL Server Import and Export Wizard)
SQL
Read Article
Top
© 2024 - ErnesTech -
Privacy
E-Commerce Return Policy
+1 (216)-435-0788
[email protected]
For peering opportunity
Autonomouse System Number:
AS401345
[email protected]
English (United States)
Spanish (Spain)
French (France)
Portuguese (Brazil)
Chinese (China)
Turkish (Turkey)
German (Germany)
Jobs
Search
CRM
Articles
Videos
Shop
Contact
Sign Up
Login
Grid-Method Tools
PDF to HTML Converter
Forums