Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8830 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / ismail hasan
truncate deletes records from a table and while truncating a
table, the table will be dropped from the database and will
again be created automatically. No where clause is
acceptable in truncate statement and one can't restore the
previous data (i.e no rollback is possible) into the table.
It's an efficient process.
Delete statement will delete a particular row(s) on your
choice.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Please explain what is “asynchronous” communication in sql server service broker?
Find columns used in stored procedure?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How to drop existing views from a database in ms sql server?
Does sql server 2016 have ssms?
Where are sql server user names and passwords stored in sql server?
How can I check if a view exists in a sql server database?
Do you know what is user defined datatypes and when you should go for them?
How would we use distinct statement? What is its use?
What is enhanced database mirroring in sql server 2008?
how will add additional conditions in sql?
Explain stored procedure?
How do I save a stored procedure in sql server?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is bcnf normalization form?
