Answer Posted / pankaj dhatrak
Truncate is more faster
reason truncate direct drop the data page and not save the transactions.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What is a trigger and types of a trigger?
Does the unique constraint create an index?
What are the differences between lost updates and uncommitted dependencies?
What do you understand by replication in sql server?
Explain go command in sql server?
What are the advantages to use stored procedures?
what are user defined datatypes? : Sql server database administration
What is the difference between mysql and mysqli?
What are the different types of subquery?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is the difference between stored procedure and user defined functions?
How do you debug a procedure in sql server?
Explain the microsoft sql server delete command? : SQL Server Architecture
How to return the top 5 rows from a select query in ms sql server?