Remove Null Rows SQL Server

DELETE
FROM TABLENAME
WHERE
(COLUMN_NAME IS NULL OR COLUMN_NAME = 0);

If you have additional columns containing NULL values and you want to refine your delete criteria

DELETE
FROM TABLENAME
WHERE
(COLUMN_NAME IS NULL OR COLUMN_NAME = 0) AND
(COLUMN_NAME_1 IS NULL OR COLUMN_NAME_1 = 0) AND
(COLUMN_NAME_2 IS NULL OR COLUMN_NAME_2 = 0) ;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s