Seven examples of SQL statement exercises remove unnecessary record rows

Copy codeThe Code is as follows:
-- I believe that we will always import data to the database, but some data records the data of all columns in the row may be null, which is not required for null data.
-- Now we need a simple query to remove these null record rows.
-- Assume that the table name is emplyees.
-- Method 1.
--- Import data to the database first
--- Second:
Select * from sys. columns
Where object_id = (select object_id from sys. objects where name = 'plyees ')

--- Method 2
--- Use the functions provided by the database
Exec sp_columns 'ployees'
Delete from Employees where coalesce (status, tel, gwei, ADDRESS1, address2, nwei) is null