SQL Data Storing – How to store data

OBJECTIVE

In this chapter you will learn:

How to store data
SQL clauses or statements for storing data

 

How to store data

In the previous chapters you have learned about SQL Server basics and retrieving clauses so now you will learn about inserting, updating, deleting etc. values in SQL database. If you have created some tables in the database then you can insert values in the table according to you but it always remember that the data type must be same and the range of the data also must be equal or less than the specified cell of the table.

SQL clauses or statements for storing data

CommandsDescription
InsertUsed to insert data in the table
UpdateUsed to modify or edit data of table
DeleteUsed to delete data from table
IncectionUsed to destroy the database

List of Storing data statements

Statements

SUMMARY

In the next chapter you have learned about SQL storing data. In the next chapter you will learn about insert command so click on NEXT button to continue learning-


Leave a Reply

Your email address will not be published. Required fields are marked *