打你一下

07 2020 档案

sql查询锁
摘要：查询锁表select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT'解锁--declare 阅读全文

posted @ 2020-07-09 14:18 打你一下 阅读(1006) 评论(0) 推荐(0)

sql删除重复记录
摘要：delete from Rebate_Logs where id not in (select max(id) from Rebate_Logs group by usercode_sk,ordercode) 阅读全文

posted @ 2020-07-09 14:16 打你一下 阅读(197) 评论(0) 推荐(0)

导航