开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜