How to truncate a table first before running a package?

Question Posted / daveriya

1 Answers
3853 Views
I also Faced
E-Mail Answers

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

What are the types of sql server?

0 Answers

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

0 Answers

explain different types of constraints? : Sql server database administration

0 Answers

What is log ldf?

0 Answers

What is sql service broker?

0 Answers

What is the purpose of UPDATE STATISTICS?

2 Answers

Is sql server is free?

0 Answers

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers Cognizant,

What is the contrast between sql and mysql?

0 Answers

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

0 Answers Value Labs,

Disadvantages of the indexes?

0 Answers

What are system databases into sql server (2005/2008)?

0 Answers

For more SQL Server Interview Questions Click Here