How.com.vn is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, 13 people, some anonymous, worked to edit and improve it over time.
This article has been viewed 116,379 times.
Learn more...
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
- Click on Start --> All Programs --> Microsoft SQL Server (2005/2008) --> SQL Server Management Studio
- Next Login with your credentials to the ServerAdvertisement
- Now right click on the Northwind Database and choose New Query
- In the new Query Window, enter the following command for SELECT
- This is the syntax for SELECT - SELECT * FROM Employees
- 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','[email protected]')
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','[email protected]'), INSERT INTO Employees values('Krystel','[email protected]'), INSERT INTO Employees values('Lines','[email protected]'). The key difference here is that every value is appended by a comma - 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
- 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
- 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
- QuestionCan you explain the steps from creation of a database to the retrieval of data from it?Community AnswerDatabase 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.
About This Article
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.