Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24469 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
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 ? | 39 Yes | 6 No |
Post New Answer View All Answers
How many types of database relationship 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 sql or structured query language?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
What is efficiency data?
Where sql server usernames and passwords are stored in a sql server?
What is clustered primary key?
What is the New in SQL server 2008?
How do I start sql server 2016?
How to install sql server 2005 express edition?
Can you pass expressions to stored procedure parameters?
What is deploy, process and build? : sql server analysis services, ssas
What is the osql utility?
How is SQL Azure different than SQL server?
How to divide query output into multiple groups with the group by clause in ms sql server?
