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
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
Explain use of expression builder.
What do you mean by table and field in sql?
How to invoke a trigger on demand?
What are 3 ways to get a count of the number of records in a table?
How do I find my localdb version?
What are recommended options to be used while using db mirroring? : sql server database administration
Why does sql studio use a single registered database repository? : sql server management studio
What do you think of this implementation? Can this be implemented better?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Why use update_statistics command in sql server?
How will you hide an attribute? : sql server analysis services, ssas
How to call a function from a stored procedure in SQL Server ?
what does the automatic recovery do? : Sql server administration
What are difference between Cluster index and Non-Cluster index?