How to Write Basic SQL Statements in SQL Server

Author Info

Last Updated: November 23, 2021

If you work with databases frequently, you might have to occasionally write basic SQL queries to retrieve and manipulate the data you need. The best way to write SQL commands is in SQL Server Management Studio. Luckily, it's pretty easy, even if you're a beginner to writing SQL. We'll show you some basic commands, like the SELECT statement, INSERT statement, and more!

1) SELECT - This command is used to retrieve information from a table

2) INSERT - This command is used to add information to a table

3) UPDATE - This command is used to modify information to a table

4) DELETE - This command is used to remove information from a table

Steps

Download Article

Advertisement
This is the syntax for INSERT -

INSERT INTO Employees VALUES('col1', 'col2') - Replace col1 and col2 with actual Values as shown below

INSERT INTO Employees values('Anil','anil@company.com')
This inserts a single row into the table.
In the even you wish to enter multiple rows at one go, you see the following command

INSERT INTO Employees values('Anna','anna@company.com'), INSERT INTO Employees values('Krystel','krystel@company.com'), INSERT INTO Employees values('Lines','lines@company.com'). The key difference here is that every value is appended by a comma

7

This is the syntax for UPDATE - UPDATE Employees SET col1 = 'new value' WHERE col1 = 'old value' - Replace col1 with actual Values as shown below

UPDATE Employees SET Name = 'Anil Mahadev' WHERE Name = 'Anil'

This is the syntax for DELETE - DELETE FROM Employees WHERE col1 = 'value' WHERE value = 'actual data row' - Replace actual data row with actual Values as shown below

DELETE FROM Employees WHERE Name = 'Anil Mahadev'

This completes this short How-To, I hope this has been beneficial to you and like to Thank You for viewing it.

Tips
Download Article

Submit a Tip
All tip submissions are carefully reviewed before being published

Name
Please provide your name and last initial

Submit

Thanks for submitting a tip for review!

Use the SQL Server Management Studio Code Snippets as hints to better your SQL Writing Skills

As you become more comfortable writing Queries, Use the SQL Query Designer to build sophisticated queries

Warnings
Download Article

Never use DELETE without a WHERE Clause in your Statements to prevent accidental deletion of rows

Same rule applies to UPDATE and INSERT as well

Always use Caution when working with the DELETE command.

Community Q&A

Search

Add New Question

Question

Can you explain the steps from creation of a database to the retrieval of data from it?

Community Answer

Database management is more complex than a single question and answer can explain. There are many free tutorials online. Start by googling "SQL tutorial" and see what you find.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 4