Categories
SQL Basic SQL query

SQL basics to retrieve data from a database table

SELECT columnname FROM tablename The first thing you should learn is how to retrieve data from a database. You do this by typing in Select column namn From table name. To search all columns, use * instead of column names. To specify which columns you want to display data from, enter their names.

Categories
SQL Basic SQL Server

How to install MSSQL

First you need to download SQL server and you can do that here: https://www.microsoft.com/en-us/sql-server/sql-server-downloads A little further down the page there are two options you can download that are free. Developer and Express. I will run the Express version but the choice is optional. Once the file is downloaded, just start the installation. Here, the […]