DSXchange

Hi,

I need to truncate a table based on a conditon.........For a column 'Input' There will be two values A and B. I need to truncate only for the value A.

Previously when there was no condition I used to use Stored Procedrue to truncate the entire table.........Now can I use SP with a condition to truncate the table.......

Please suggest me an

Thanks in Advance.......
Purush

what database are you using?

you can't truncate with a condition, that would be performing a delete.

If you partition your table by the column in question you could drop the partition which will probably be quicker that a delete if you have a huge table.

Can you approach this as a series of discrete steps? Evaluate your condition, possibly truncate, etc - all controlled in a Sequence job by triggers?

Is the question IF condition THEN truncate ELSE don't or is the question truncate only certain rows?