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

How to check if a table is being used in sql server?

How send email from database?.

Can we call SP inside a query?

How will you go about resolving deadlocks?

What is the use of =,==,=== operators?

How to connect sql server management studio express to sql server 2005 express?

How to create a local temporary stored procedure?

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

Explain fundamentals of Data ware housing & OLAP?

What is lookup override?

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

For more SQL Server Interview Questions Click Here