摘要:
USE [master]GOalter database IotTY set EMERGENCYalter database IotTY set single_user --修复数据库DBCC CHECKDB(IotTY,REPAIR_ALLOW_DATA_LOSS)dbcc checkdb(Iot 阅读全文
摘要:
SQL 分组后获取其中一个字段最大值的整条记录 方法一:(效率最高)select * from test as a where typeindex = (select max(b.typeindex) from test as b where a.type = b.type );方法二:(效率次之) 阅读全文