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 is 2nf example?
What is difference in performance between insert top (n) into table and using top with insert?
What are SSL and TSL protocols?
How to use copy and concatenate commands in SQL?
What is the Difference Between Primary and Foreign Key?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
Explain unique key in sql server?
What are the different types of cursor?
What is the syntax to execute the sys.dm_db_missing_index_details?
What is difference between joins and subqueries?
what are different types of backups available in sql server? : Sql server database administration
What is the importance of three tier architecture?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Explain about builtinadministrator?
Differentiate between SQL and ORACLE joins and write their syntax.