如何从SQL表中删除空行 [英] How to delete empty rows from SQL table

问题描述

问候所有，

我有一个sql表，我想从表中删除所有空行。

任何帮助？



我尝试了什么：

Greetings all,
I have an sql table and I would like to delete all empty rows from the the table.
Any help?

What I have tried:

protected void DeleteEmptyRow()
        {

           
                SqlConnection connection1 = new SqlConnection(@"Data Source=CEn-PC\SQLEXPRESS;Initial Catalog=UserData;Integrated Security=True");
                SqlDataAdapter adapter = new SqlDataAdapter("SELECT *FROM AuditReport", connection1);
                DataTable dt = new DataTable();
                adapter.Fill(dt);

            for (int i = dt.Rows.Count - 1; i >= 0; i--)
            {
                DataRow row = dt.Rows[i];
                SqlCommand sqlComm1 = new SqlCommand(@"DELETE FROM AuditReport WHERE '" + row[0] + " like "+null+"'", connection1);
            }

            for (int i = dt.Rows.Count - 1; i >= 0; i--)
            {
                DataRow row = dt.Rows[i];
                SqlCommand sqlComm1 = new SqlCommand(@"DELETE FROM AuditReport WHERE '" + row[0] + " like " + string.IsNullOrEmpty(row[0].ToString()) + "'", connection1);
            }

        }

推荐答案

DELETE FROM AuditReport WHERE myColumn IS NULL OR trim(myColumn) = '';

这篇关于如何从SQL表中删除空行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！