What is difference between TRUNCATE & DELETE?
Answer Posted / pravallika
We can specify a condition while using deletecommand.But
Truncate is unconditional
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
what is collation? : Sql dba
What do you mean by stored procedures?
what is sub-query? : Transact sql
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What is a data manipulation language?
What is the difference between inner join and natural join?
What is a parameter query?
What does joining a thread mean?
what is the difference between myisam static and myisam dynamic? : Sql dba
Why use stored procedures?
How exception is different from error?
what are rollup and cube in t-sql? : Transact sql
Why are sql stored procedures used?
Write a sql query to get the third highest salary of an employee from employee_table?
how to start mysql server? : Sql dba