Help needed : Truncating a table based on a condition

krish_princi · #1 (**permalink**) 09-04-11, 01:57

Dear Friends,

I am writing a script and want to execute from the OS level. I have one doubt, How do I truncate the table based on some condition. Here let us assume that I want to truncate the whole table if the count(*) reaches 200,000. Please provide syntaxes for the same.

krish_princi · #2 (**permalink**) 09-04-11, 03:49

Please reply .. :'( im eagerly waiting.

pradyut.dhara · #3 (**permalink**) 09-04-11, 08:39

Hi,
Following syntax can be used.

Code:

if exists(select 1 from T1 having count(1)>200000 )
begin
	exec ('truncate table T1')
end
go

OR

Code:

if (select count(*) from T1) >200000
begin
	exec ('truncate table T1')
end
go

krish_princi · #4 (**permalink**) 09-07-11, 02:05

Thank you very much friend.

Internet Services

Web Development

Digital Marketing

Consumer Tech