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.......
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.