How to truncate a table first before running a package?

Question Posted / daveriya

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

Answer / ram

truncate table table_name;

Is This Answer Correct ?

2 Yes

3 No

More SQL Server Interview Questions

Explain database normalization?

Equi join and non equi join is possible with sql server?

Do you know what is similarity and difference between truncate and delete in sql?

How to use union to merge outputs from two queries together in ms sql server?

Can you tell me about the concept of ER diagrams?

How to find the source of a table in sql server?

What is deadlock and how to avoid the deadlocks.

Explain transaction server isolation?

How to loop through result set objects using odbc_fetch_row()?

What are the differences between triggers and stored procedures?

What is a system database and what is a user database?

How do you trace the traffic hitting a sql server?

For more SQL Server Interview Questions Click Here