C#sql去除换行符

            SqlConnection conn = new SqlConnection("server=.; uid =sa; pwd = *****; database = 数据库; Max Pool Size = 512;");
            conn.Open();


            string sql = "update 文章列表 set 附件三=replace(附件三, char(10),'')";


            SqlCommand com = new SqlCommand(sql, conn);
            com.ExecuteNonQuery();
            conn.Close();

            MessageBox.Show("ok");


winform代码
桂ICP备16004754号