How to truncate a table first before running a package?

Answer Posted / ram

truncate table table_name;

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what stored procedure can you use to display the current processes? : Sql server administration

528


Can we add an identity column to decimal datatype?

577


Where actually sql azure database is hosted?

149


How to drop an existing table?

545


What is simple indexing method?

571






You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

600


How data can be copied from one table to another table?

507


How to delete duplicate rows?

546


What happens on checkpoint?

612


How does the report manager work in SSRS?

116


What is a recursive stored procedure in sql server?

569


How to use values from other tables in update statements in ms sql server?

551


What is scheduled job and how to create it?

546


What are the benefits of filtered indexes?

507


Does a sql server 2005 select statement require a from?

578