Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25559 Views
- I also Faced
- E-Mail Answers
Answer Posted / vijay dev arya
Delete command removes the rows from a table based on the
condition that we provide with a WHERE clause. Truncate will
actually remove all the rows from a table and there will be
no data in the table after we run the truncate command.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Can you explain about buffer cash and log cache in sql server?
How many databases can we create in a single server?
Explain what are the authentication modes in sql server?
What is bulkcopy in sql?
How to get all stored procedures in sql server?
How to create a simple table to test triggers in ms sql server?
Why should we go for stored procedures? Why not direct queries?
How can you fetch alternate records from a table?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What are the types of user defined functions in sql server?
What is plan freezing?
What stored by the master?
Difference between group by clause and having clause in SQL?
What is sqlcmd?
What is the difference between osql and query analyzer?
