⟩ TRUNCATE TABLE EMP; DELETE FROM EMP; Will the outputs of the above two commands differ?
Both will result in deleting all the rows in the table EMP..
Question and Answer:
Home SQL
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Tell us what Is The Difference Between Lock, Block And Deadlock?
Tell us what is the difference between Clustered and Non-Clustered Index?
Tell me when setting Replication, can you have Distributor on SQL Server 2005, Publisher of SQL Server 2008?
Explain me what is DBCC?
Tell me how do you troubleshoot errors in a SQL Server Agent Job?
Tell us what is SQL Server Agent service and its importance?
Tell us do you have experience with on-premises databases, cloud databases or both?
Please explain what the different types of Replication and why are they used?
Tell us what are the different SQL Server Versions you have worked on?
Tell us what is SQL Server Integration service and its importance?
