1. 查询两张表中一致的数据
select * from a
intersect
select * from b
2. 查询两张表中不一致的数据
select * from b
except
select * from a
3. 查询死锁
SELECT request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName
FROM sys.dm_tran_locks
WHERE resource_type='OBJECT '
根据spid 查询造成死锁的语句
DBCC INPUTBUFFER(80)
结束死锁进程
KILL 80
4. 重置自增编号变为0
dbcc checkident('tablename',reseed,0)