In previous post we explain some How to add captcha to web form in asp.net , How to Add splash in window form and most popular post How to make an .exe file of window based project with full of screenshot and a related post Introduction to SQL that is one post in this topic
In this post we will explain the Different types of SQL statement. On the basis of operation perfomed by statement, these can be divided into differ types as given below:-
2) DML– Stand for "Data Manipulation language". A DML language is used to perform some operation in the database like
3) DRL– Stand for "Data Retrieval Language" and used to reterive the data from the database to manipulate or show it on the front end application. The stament that is come under this category is "select statement".
5) DCL – Stand for "Data Control Language".Data Control Language is used for the control
Notice : Now Please click on the below or right hand side Adds .
In this post we will explain the Different types of SQL statement. On the basis of operation perfomed by statement, these can be divided into differ types as given below:-
1) DDL(Data Definition Language) -Stands for "Data Definition Language." A DDL is a language used to define data structures within a database. It is typically considered to be a subset of SQL, the Structured Query Language, but can also refer to languages that define other types of data.
A Data Definition Language has a pre-defined syntax for describing data. For example, to build a new table using SQL syntax, the CREATE command is used, followed by parameters for the table name and column definitions. The DDL can also define the name of each column and the associated data type. Once a table is created, it can be modified using the ALTER command. If the table is no longer needed, the DROP command will delete the table.
- INSERT - insert data into a table
- UPDATE - updates existing data within a table
- DELETE - deletes records from a table, the space for the records remain
4) TCL- Stand for "Transaction Control Language" that are used to manage the changes made by DML statements. It allows statements to be grouped together into logical transactions. Statement that come under in this category are listed below:-
- COMMIT - save work done
- SAVEPOINT - identify a point in a transaction to which you can later roll back
- ROLLBACK - restore database to original since the last COMMIT
- SET TRANSACTION - Change transaction options like isolation level and what rollback segment to use
of data. That is a user can access any data based on the priveleges given to him. This is done
through DCL.These are given below:-
- GRANT - used to give permission to any person so that one can access that data.
- REVOKE - used to deny to any person so that one can access that data.
