摘要：
--1、最接近当天的数据 当天再次排序select * from CSI_MagicPower order by datediff(d, CreateDate,GETDATE())--0、修改自增字段的初始值DBCC CHECKIDENT('表明', RESEED, 初始值)--1、锁select request_session_id as spid,OBJECT_NAME(resource_associated_entity_id) as tableNamefrom sys.dm_tran_lockswhere resource_type='OBJECT'-- 阅读全文