How can we write or define DDL statements in Sql server and
DML statements?
Answers were Sorted based on User's Feedback
Answer / simran_8185@rediff.com
DDl is a data defination language means we are defining
like create is a DDL statement
Eg: create table Emp(name varchar(20),address varchar(40));
whereas DML is a Data Manipulation Language in which
updations are made like
update table Emp set name="Ravi" where name="Anil"
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / raju vikram
Delete is DDL statement and Truncate is DML statement
Is This Answer Correct ? | 3 Yes | 8 No |
Where are full-text indexes stored?
How do you clear a log file?
How to set the current database in ms sql server?
Explain how to use linked server?
What is indexed view? How to create it?
How to find the login name linked to a given user name?
what is a live lock? : Sql server database administration
Explain comment on transactions?
What is temporal data type?
What do we need queues in sql service broker?
How to implement service broker?
If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?