Interested to Buy Any Domain ? << Click Here >> for more details...
How can we write or define DDL statements in Sql server and
DML statements?
- 3 Answers
- 6348 Views
- I also Faced
- E-Mail Answers
Answer Posted / kalyana chakravarthy maddipati
DDl statements like Create, Alter, Drop and Truncate can't be Rollbacked and Committed implicitly where as DML statements like Insert, Update and Delete can be rollbacked. DML statements has to be comitted explicitly
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What do you do in data exploration
How dts is used to extract, transform and consolidate data?
How to change the password of a login name in ms sql server?
Explain the creation and execution of a user-defined function in the sql server?
What are the drawbacks of reporting in ssrs?
Can we insert data into a view?
How to create function with parameter in sql server?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
How to execute a stored procedure in ms sql server?
what is the different types of backups available in sql server? : Sql server database administration
Does index slows down insert statements?
what is a schema in sql server 2005? : Sql server database administration
Why we use functions in sql server?
How to get the definition of a user defined function back?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
