Introduction:- There are two types of statements used in SQL Server
1.) DML(Data Manipulation Language):- Some Commands of DML are:
1.) DML(Data Manipulation Language):- Some Commands of DML are:
- SELECT :-Retrieve information from the database.
- INSERT:-Insert data into a table.
- UPDATE:-Update Existing Records in a table.
- DELETE:- Delete Records in a table.
- CREATE:-Create table in database.
- ALTER:-Modify the structure of database.
- DROP:- Delete the table in database.
- TRUNCATE:-Remove all records from the table including all allotted space also.
- COMMENT:- It is used for comment.
- RENAME:- Rename the objects.
Here we will perform select, insert,Update and Delete commands in a single Stored Procedure in sql server.