How can we write or define DDL statements in Sql server and
DML statements?
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 understand by triggers?
What are views in ms sql server?
Can you explain what is sql server english query?
What are the different types of triggers in SQL SERVER?
How to create an index on a view?
What is a livelock?
Explain sub-query?
Why use cursor in sql server?
what are the disadvantages of cursors? : Sql server database administration
What are the purposes of floor and sign functions?
What are the different editions available in sql server 2000?
How to enforce security in sql server? : sql server security
Explain what is lock escalation and what is its purpose?
What are the different types of subquery?
What are data resources?