Write SQL using the command line without opening the SQL tool

Idle bored, heard the company test computer Open database too card, affect office, simply teach him how to use the command line to check SQL.

Open the console, enter osql?/command to display the database operation interface

-S: Login server name-u: Login user name-P: login Password

Osql-s xxx-u xxx-p xxx

Use XXX

Go

SELECT * FROM table

Go

Very simple operation, the picture is too lazy to post.

According to the above instructions, you can happily look up SQL.

Write SQL using the command line without opening the SQL tool