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
- 6499 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
Difference between report and query parameter. Why do we need different type of parameter?
What are the dis_advantages of stored procedures, triggers, indexes?
What do you mean by tablesample?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
How network traffic be reduced by using the stored procedure?
What is a dbms wizard?
What is pivot and unpivot?
Tell me about normalization in DBMS.
What is forward - only cursors / read only cursor?
What are the differences between user defined functions and stored procedures?
Explain nested join?
What is the difference between a "where" clause and a "having" clause?
What is subquery in sql?
Explain the cursor lock types?
What is left outer join in sql server joins?
