How can we write or define DDL statements in Sql server and
DML statements?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / raju vikram
Delete is DDL statement and Truncate is DML statement
Is This Answer Correct ? | 3 Yes | 8 No |
What is sql injection and why is it a problem? : sql server security
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
What does COMMIT command do?
Explain the truncate command?
What is snapshot replication?
What is difference between count (*) and count column?
Explain basic SQL queries with SELECT from where Order By, Group By-Having?
What are various aggregate functions that are available?
Explain indexed views and partitioned view with their syntax.
Explain about temporary stored procedure?
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha
Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?