12 2010 档案

摘要:连接1:set lock_timeout 1000waitfor time '12:08'update mm set istop=0 where id in (select top 1 id from mm with(readpast))连接2:set lock_timeout 1000waitfor time '12:08'update mm set istop=0 where id in (select top 1 id from mm with(readpast))没有出现并发问题 均可更改并且没有发生死锁 阅读全文
posted @ 2010-12-26 23:12 老高dotnet实践 阅读(175) 评论(0) 推荐(0) 编辑
摘要:连接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实践 阅读(199) 评论(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实践 阅读(96) 评论(0) 推荐(0) 编辑
摘要:SELECT Name FROM SysObjects Where XType='U' and [name] like '%关键字%'ORDER BY Name 阅读全文
posted @ 2010-12-19 14:28 老高dotnet实践 阅读(80) 评论(0) 推荐(0) 编辑
摘要:SELECT 表名 = CASE WHEN A.COLORDER=1 THEN D.NAME ELSE ' ' END, 表说明 = CASE WHEN A.COLORDER=1 THEN ISNULL(F.VALUE, ' ') ELSE ' ' END, 字段序号 = A.COLORDER, 字段名 = A.NAME, 标识 = CASE WHEN COLUMNPROPERTY( A.ID,A.NAME, 'ISIDENTITY ')=1 THEN '√ 'ELSE ' ' END, 主键 = 阅读全文
posted @ 2010-12-19 13:21 老高dotnet实践 阅读(256) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示