Thursday, February 19, 2015

DML (DATA MANIPULATION) Commands in SQL Server

11:58 AM - By ajay desai 0


DATA MANIPULATION LANGUAGE

this language deals with manipulation of data stored in a database table. It uses commands like: -

(i)                            Insert: - This command is used to insert a selected record/row in a database table.

For ex:- insert into customer values(105,'suresh',9000,null,null)
As shown in the above given statement, we can insert Null value for a column explicitly.

insert into customer(custid,cname,status) values(103,'ajay',1)
As shown in the above given statement, if a value is not inserted into a specific column, Null gets stored into the column. Because, the default value for every column is Null.

(ii)            Delete: - this command is used to delete selected no: of records from a database table.
For ex: - delete from student where sid=101

(iii)                       Update: - this command is used to update selected no: of records in database table.

                     For ex: - update student set sid=104 where sid=102







Tags:
About the Author

I am Azeheruddin Khan having more than 6 year experience in c#, Asp.net and ms sql.My work comprise of medium and enterprise level projects using asp.net and other Microsoft .net technologies. Please feel free to contact me for any queries via posting comments on my blog,i will try to reply as early as possible. Follow me @fresher2programmer
View all posts by admin →

Get Updates

Subscribe to our e-mail newsletter to receive updates.

Share This Post

0 comments:

adsense

© 2014 Fresher2Programmer. WP Theme-junkie converted by Bloggertheme9
Powered by Blogger.
back to top