To use select statement in a delete statement using MSSQL you can use the snippet below.
Sample MSSQL
DELETE TableOne FROM TableOne INNER JOIN TableTwo ON TableTwo.Id= TableOne.Id AND ... WHERE ...
To use select statement in a delete statement using MSSQL you can use the snippet below.
DELETE TableOne FROM TableOne INNER JOIN TableTwo ON TableTwo.Id= TableOne.Id AND ... WHERE ...
To remove columns from DataTable in C# and VB.NET you can use the snippet below.
DataTable dataTable; dataTable.Columns.Remove("Columnname"); dataTable.Columns.RemoveAt(index);
Dim dataTable As DataTable dataTable.Columns.Remove("Columnname") dataTable.Columns.RemoveAt(index)