Sql Server 2005 Bulk XML Delete?
I know you can do bulk XML inserts into SQL Server 2005 tables from your C# code using datasets/datatables. Is it possible to开发者_JAVA百科 do the same but as a delete?
You can remove data two ways
DELETE FROM Schema.TableName WHERE Condition = Value
OR nuke it
TRUNCATE TABLE Schema.TableName
Now, if you want to Bulk Delete rows based on an XML file, you are going to have to import the data into a staging table or open it as a rowset and then do a JOIN
or EXISTS
to delete.
精彩评论