delete is used to destroy a single object. It will call the destructor of the object and free the memory. delete[] is used to free the memory which was allocated using new []. delete [] will call the destructor for each object in array and free the memory. ________________ As far as I can tell, they aren't delete bit different.
Delete: When you use Delete command, it deletes all the data or some specific data from a table. It will not release the memory space used by those data. For that you can rollback the deleted data.
Truncate: When you use Truncate command, it deletes all the data from a table and also releases the memory space occupied by those data. For that you can not rollback the data, when a table is truncated.
*******************
Truncate: Cut off/cut short leaving a remnant.
Delete: Remove completley.
Normally a delete is a piece of text you want to remove permanently. When you cut a piece of text you leave yourself the option of pasting it in another place. So you store it in memory for the time being.
I find cut and paste most useful when I write. I tend to write the conclusion of a paragraph first. Then I write the introduction. Then I write the body. Then I can cut the first sentence and move it to the last sentence in the paragraph. My paragraph then follows a logical progression. Later when the writing gets cold, I come back and do more cutting and pasting and also do some deleting where the logic does not make sense or does not really follow a logical progression. Cut is to cut and paste. Delete carries out the garbage.
What is the difference between delete and format?
delete command would delete selected word,line, paragraph or even sheet. Whereas delete sheet command would delete the whole sheet
i don't know the difference but what i know is ... deleted file from MS-DOS is never go to the recycle bin. Thanks !
The backspace key deletes to the left of the cursor, and the delete key deletes to the right of the cursor.
The delete key removes the character above or to the right of the cursor. The backspace removes the character to the left of the cursor.
Delete key deletes any amount of text. The left arrow key only moves the I beam
ExecuteQuery() :To Execute SELECT StatementExecuteNonQuery() :To Execute Other Than Select Statements (INSERT/UPDATE/DELETE)
DEL key (delete key) gets rid of the things on front of the cursor. Backspace gets rid of things behind the cursor.DEL key is used to delete files
The query is simple set of insert,update,delete statement where as transaction is a set of statement which follows ACID properties.
Delete statement deletes only the data from the table but you can apply some condition and only part of the data can be deleted. Truncate empties entire table. Drop deletes the table itself.
The basic difference between DDL and DML is the commands they provide . The DDL provides statement for the creation and deletion of tables, indexes, views etc. while the DML provides statements to enter, update, delete and perform complex queries on these tables.
Once data is truncated it can not be rolled back (recovered). However, data can be rolled back if deleted accidentally.