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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to implement service broker?

521


How much memory that we are using in Logshipping Concept?

1364


Different types of keys in SQL?

620


Do you know exporting and importing utility?

529


What are sparse columns?

584






Can sql servers link to other servers?

557


What is the filtered index?

555


What is system stored procedures?

579


Does group by sort data?

509


What is the difference between left and right outer join?

537


What are sub reports?

149


Why should we go for stored procedures? Why not direct queries?

570


What is the maximum number of index per table?

560


Explain about analysis services?

569


What are the limitations/drawbacks or ssrs 2008 r2?

86