what is the difference between Delete and Truncate
Answer Posted / manoj pandey
Check following blog post for Difference Delete vs Truncate: http://sqlwithmanoj.wordpress.com/2009/02/22/difference-between-truncate-delete-and-drop-commands/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What’s the distinction between dropping a info and taking a info offline?
How to delete an existing database user?
What is precedence constraint?
What are the 10 characteristics of data quality?
Can foreign key be deleted?
Explain four layers of abstraction microsoft architectured?
What is the use of tempdb? What values does it hold?
What are the operating modes in which database mirroring runs?
Write the SQL query to drop, truncate and delete table.
what's the difference between a primary key and a unique key? : Sql server database administration
What is a collation in ms sql server?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What are the different types of Indexes available in SQL Server?
Is sql server 2016 free?