Instructions About Writing SQL Statements in SQL Server

The following instructions give step by step directions for how to walk you through writing basic SQL Statements in SQL Server. SQL Statements are used to work with databases whether it be retrieving or manipulating data. In order to retrieve and manipulate data you must learn how to get your hands dirty and understand how to write simple queries on the server. This simple instruction set aims to assist students or beginners for this tutorial and should take around ten minutes to complete.

Supplies

We will be focusing on 4 primary areas for this tutorial: SELECT, WHERE, AND and ORDER BY commands. Each command is used to retrieve, add, modify or remove information from a table.

Step 1: Search

Search for Microsoft SQL Server Management Studio 18 in the windows search tab and click on it

Step 2: Login

Step 3: New Query

Now click on New Query in the upper left hand corner (see picture)

Step 4: SELECT Statement

Type “Select * From ‘Table_name’”, as shown in the picture, This statement is a syntax example of how to write a SELECT statement to select data from a database

Step 5: WHERE Statement

Type “Select * From ‘Table_Name’ Where ‘Condition’”, this creates the WHERE clause, which is used to filter records and used to extract records that fulfill a specified condition

Step 6: AND Statement

Type “Select * From ‘Table_Name’ Where ‘Condition’ and ‘condition’ and ‘condition’...” to combine the WHERE clause with the AND operator. It displays a record if all the conditions separated by AND are true.