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

Determine when to use stored procedure to complete sql server tasks?

710


Can we install sql server 2016 on windows 7?

865


How to name query output columns in ms sql server?

713


what are different types of backups available in sql server? : Sql server database administration

674


What are the elements of dbms?

711






How do you implement session management in SQL Server mode?

718


What are the requirements for sql server 2016?

687


What is query cost in sql server?

746


Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

751


How to Check if table exists in sql server?

788


What is the architecture of ms sql reporting service?

702


What are some examples of schemas?

705


How many types of subqueries are there in sql server?

657


What is difference between commit and rollback when used in transactions?

664


What are a scheduled jobs or what is a scheduled tasks?

653