Interested to Buy Any Domain ? << Click Here >> for more details...
How can we write or define DDL statements in Sql server and
DML statements?
- 3 Answers
- 6496 Views
- I also Faced
- E-Mail Answers
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 are sql dirty pages?
What options are available to audit login activity? : sql server security
What is pivot and unpivot?
Can you use order by when defining a view?
What are the two modes of authentication in sql server?
Can we use having clause without group by?
What is collation sensitivity?
Which table keeps information about stored procedures?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What is the order in which the sql query is executed?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is the log shipping?
What are the five characteristics of good data?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
