摘要: 连接1:SET TRANSACTION ISOLATION LEVEL READ COMMITTED begin transactionselect top 4 * from admin_inputproducts with(updlock,readpast) where istop=1waitfor time '10:37'commit连接2: //连接1读取到的记录连接2是不会读取的。SET TRANSACTION ISOLATION LEVEL READ COMMITTED begin transactionselect top 4 * from admin_inputp 阅读全文
posted @ 2010-12-25 22:55 老高dotnet实践 阅读(205) 评论(0) 推荐(0)
摘要: alter database d1 set recovery simple --设置数据库恢复模型 alter database d1 set recovery bulk_logged alter database d1 set recovery full 阅读全文
posted @ 2010-12-25 14:37 老高dotnet实践 阅读(104) 评论(0) 推荐(0)