What is difference between TRUNCATE & DELETE?
- 16 Answers
- 39647 Views
- Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
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
Can I create table without primary key?
What are the 3 types of behavioral triggers?
Why do we use view in sql?
how to decrement dates by 1 in mysql? : Sql dba
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What are the operators used in select statements?
What is the use of non clustered index?
How many unique keys can a table have?
How do I trace sql profiler?
Is a secondary key the same as a foreign key?
How is indexing done in search engines?
What is clause in sql?
Explain raise_application_error.
What is sql indexing?
how to include numeric values in sql statements? : Sql dba
