Sql Server Languages

5 followers

84 daily readers

rank of 584

Sql Server Languages

July 4th 2008 10:24

SQL Server

DML
DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database. Examples: SELECT, UPDATE, INSERT statements

DDL
DDL is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database. Examples: CREATE, ALTER, DROP statements

DCL
DCL is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it. Examples: GRANT, REVOKE statements

TCL
TCL is abbreviation of Transactional Control Language. It is used to manage different transactions occurring within a database.

Vote

Add To:

subscribe to this blog by email

follow this blog on Orble

start your own blog

[ Link ]

Posted By: Siddharth sood - Category: No Category

Related Posts:

Relate This Post

Recent Posts:
      Different ways to execute a SQL Agent job
      When was the last time your SQL Server database was restored
      Handling workloads on SQL Server 2008 with Resource Governor
      Collecting performance counters and using SQL Server to analyze the data
      SQL Server UDF to convert integer date to datetime format
      Handling cross database joins that have different collations (SQL Server)
      Server level permissions for SQL Server 2005 and 2008
      Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)
      Dropping multiple objects with a single DROP statement
      Implementing Database Mirroring in SQL Server 2005 across domains

[ Previous - The Many Uses of Coalesce in SQL Server ]

[ Next - SQL Server function to determine if all characters in a string are capitalized ]

Add A Comment

To create a fully formatted comment please click here.

CLICK HERE TO LOGIN | CLICK HERE TO REGISTER

Name or Orble Tag

Home Page (optional)

Comments

Notify me of replies

Notify extra people about this comment

Is this a private comment?

List the Email Addresses or Orble Tags of the people you would like to be notified about this comment

One per line max of 30

List the Email Addresses or Orble Tags of the people you would like to be notified about this private comment thread. Only the people in this list will be able to see or reply to your comment.

One per line max of 30

Your Name
(for the email going out to the above list, it can be different to your Orble Tag)

Your Email Address

(optional)

(required for reply notification)

Submit

April 2009

4 Posts

March 2009

11 Posts

February 2009

1 Posts