How can we write or define DDL statements in Sql server and DML statements?

How can we write or define DDL statements in Sql server and
DML statements?

Question Posted / arijit bhawal

3 Answers
6662 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can we write or define DDL statements in Sql server and DML statements?..

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

How can we write or define DDL statements in Sql server and DML statements?..

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

How can we write or define DDL statements in Sql server and DML statements?..

Answer / raju vikram

Delete is DDL statement and Truncate is DML statement

Is This Answer Correct ?

3 Yes

8 No

Post New Answer