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
What is database architecture? : SQL Server Architecture
What is an etl file?
How to convert a table data in XML format in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is bulkcopy in sql?
what is unique and xaml nonclustered index
What is mean by dml?
Show Practically Sql Server Views are updatable?
Can a database be shrunk with users active?
Do you know what is difference between index seek vs. Index scan?
Tell me what is normalization? Explain different forms of normalization?
How to truncate the log in sql server 2012? : sql server database administration
How do I save a stored procedure in sql server?
What is normalization of database?
Explain a join?