]]>By: kumar.shttp://blog.sqlauthority.com/2008/01/15/sql-server-what-is-dml-ddl-dcl-and-tcl-introduction-and-examples/#comment-1656267
Fri, 30 Jan 2015 04:47:19 +0000http://blog.sqlauthority.com/2008/01/15/sql-server-what-is-dml-ddl-dcl-and-tcl-introduction-and-examples/#comment-1656267hi dude …I have one doubt …in sql I have create a one table …unfortunately that table has been deleted …if any command is there to recover that table..

]]>By: Rahul Diwakarhttp://blog.sqlauthority.com/2008/01/15/sql-server-what-is-dml-ddl-dcl-and-tcl-introduction-and-examples/#comment-1610486
Fri, 02 Jan 2015 10:14:56 +0000http://blog.sqlauthority.com/2008/01/15/sql-server-what-is-dml-ddl-dcl-and-tcl-introduction-and-examples/#comment-1610486thnx mate,
i appreciate your help for us.. its really very help full,
i m a beginner, and i hope u will help out my my doubts,
thnx once again…

]]>By: shalinihttp://blog.sqlauthority.com/2008/01/15/sql-server-what-is-dml-ddl-dcl-and-tcl-introduction-and-examples/#comment-1180140
Mon, 28 Jul 2014 06:35:05 +0000http://blog.sqlauthority.com/2008/01/15/sql-server-what-is-dml-ddl-dcl-and-tcl-introduction-and-examples/#comment-1180140Hello sir, I want to know that how char and varchar works.
Ex. shalini and shalini05 will work for char?

]]>By: Roberthttp://blog.sqlauthority.com/2008/01/15/sql-server-what-is-dml-ddl-dcl-and-tcl-introduction-and-examples/#comment-932343
Wed, 19 Mar 2014 13:59:45 +0000http://blog.sqlauthority.com/2008/01/15/sql-server-what-is-dml-ddl-dcl-and-tcl-introduction-and-examples/#comment-932343Great post. I was checking constantly this weblog and I’m inspired!
Extremely useful information particularly the
closing part :) I care for such information a lot. I used to be seeking this particular information
for a very lengthy time. Thank you and best of luck.

Transaction Control (TCL) statements are used to manage the changes made by DML statements. It allows statements to be grouped together into logical transactions.
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

]]>By: rajinder kaurhttp://blog.sqlauthority.com/2008/01/15/sql-server-what-is-dml-ddl-dcl-and-tcl-introduction-and-examples/#comment-534004
Wed, 24 Jul 2013 04:53:24 +0000http://blog.sqlauthority.com/2008/01/15/sql-server-what-is-dml-ddl-dcl-and-tcl-introduction-and-examples/#comment-534004SIR IF WE USING NULL THAN WE AVAIL SPACE FOR THAT COLUMN