SQL Server 2012 how do I view data?

I have several tables in my database and I am using the SQL Server Management Studio for the first time. I want to see the data. In an SQLite 3 or MySQL

I’d simply type SELECT * FROM tblName WHERE...

the output would be in my console.

Answer

In SSMS open a new query window (Ctrl + n), make sure the database is selected from the databases dropdown (Ctrl + d to focus to the list, then up/down arrows and Enter to select the DB), write the query and F5 to run.

You can use the mouse for all of the above (there is a toolbar button for new query window, and you can use the mouse for selecting the DB).

An alternative is to use the object browser to drill down to the database and table in question, right click on the table name and select the “Select top 1000 rows…” (or similar) option.