How to truncate a table first before running a package?



How to truncate a table first before running a package?..

Answer / ram

truncate table table_name;

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More SQL Server Interview Questions

You are doing log shipping due to some reasons it is failing. How you will proceed from there

0 Answers  


Distinguish between nested subquery and correlated subquery?

0 Answers  


How to create and drop temp table in sql server?

0 Answers  


hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  


what is normalization? Explain different levels of normalization? : Sql server database administration

0 Answers  






Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  


Define DML and DCL statements?

1 Answers   Hexaware, NIIT,


What is sql server transaction log file?

0 Answers  


how do we find every fifth record in a table

14 Answers   Aspire, HCL,


What is 1nf normalization form?

0 Answers  


What is data source object?

0 Answers  


What is the difference between implicit and explicit transaction?

0 Answers  


Categories