How to crop a table with SQL Server 2008?

Question

I want to crop the table, but when the column value is NULL

 truncate table FB_Player where FB_Player.Status ='NULL' 

Answer 1

You cannot use Where Where truncated. Truncate clears all data from a table without any conditions. Instead, you use the Delete command.

Answer 2

You are looking for Delete not Truncate .

You cannot use the where clause with TRUNCATE .

You can try the following: -

 delete from FB_Player where FB_Player.Status is NULL 

From wiki

You cannot specify a WHERE clause in a TRUNCATE TABLE statement — that's all or nothing.