Type Of TSQL Command

In this article I demonstration of  Type of TSQL Command

Types of TSQL Command:-

                  

      All   the command in TSQL are classified into following 5 categories

1)Data Defination Language (DDL):-

           All the commands of  TSQL  that are used to create object,alter the structure of objects and delete the object are collectively called as DDL

   1)CREATE

   2)ALTER

   3)DROP

   4)TRUNCATE

2)Data Manipulation Language (DML):-

           All the commands of  TSQL  that are used to store the data into the database ,modify the database and delete the data  are collectively called as DML

   1)INSERT

   2)UPDATE

   3)DELETE

3)Data Query Language (DQL):-

           All the commands of  TSQL  that are used to request data from database are called as DQL

    1)SELECT

4)Data Control Language (DCL):-

           All the commands of  TSQL  that are used to allow the user to access  the data or restrict the user from accessing the data  are collectively called as DCL

1)GRANT

2)REVOKE

3)DENY

5)Transaction Control Language (TCL):-

           All the commands of  TSQL  that are used to create and manage the transaction  are collectively called as DML

   1)Begin Transaction

   2)Commit Transaction

   3)Rollback Transaction

  4)Save Transaction

If you have any query  then frankly  leave mail me dotnetbyabhipatil@gmail.com

                           OR

For more article  visit my blog

 http://dotnetbyabhipatil.blogspot.in

  

            

• Tweet
• Share
• Share
• Share
• Share

About Abhijit Patil

Abhijit Patil is a Founder of Dotnetbyabhipatil ,he Passionate on Technology ,He have 3 Award on dotnetspider Including Golden. He got 2nd Time MVP(Most Valuable Professional) award at Delhi International Conference on C# Corner. also Chapter Lead of C# Corner Pune Chapter.

Related Post