Whenever you roll back a transaction, it nullifies the effect of every command you’ve executed since

you started the transaction. But what happens if you want to roll back only part of an ongoing transaction?

成都创新互联公司专注于仁布企业网站建设,成都响应式网站建设公司,电子商务商城网站建设。仁布网站建设公司,为仁布等地区提供建站服务。全流程按需求定制开发，专业设计，全程项目跟踪，成都创新互联公司专业和态度为您提供的服务

SQL Server handles this with a feature called savepoints.

Savepoints are markers that act like bookmarks. You mark a certain point in the flow of the transaction,

and then you can roll back to that point. You set the savepoint using the Transaction.Save()

method. Note that the Save() method is available only for the SqlTransaction class, because it’s not

part of the standard IDbTransaction interface.

网站名称：SavePoint-创新互联
链接分享：http://myzitong.com/article/jchgh.html