摘要:
select name,snapshot_isolation_state,snapshot_isolation_state_desc from sys.databasesname snapshot_isolation_state snapshot_isolation_state_desc-------------- ------------------------ ------------------------------------------------------------master 1 ONtempdb 0 OFFmodel 0OFFmsdb 1ONSmoke 1ONsnapsh 阅读全文
摘要:
select [File_Name]=[name], File_Mb= convert(float,size) * (8192.0/1024.0)/1024. from dbo.sysfiles 阅读全文
摘要:
SELECT name FROM sys.all_columns WHERE OBJECT_ID=OBJECT_ID('要查询的表名') 阅读全文
摘要:
select "表名"= convert (varchar (50), o.name), "行数"=i.rowsfrom sysobjects o (nolock), sysindexes i (nolock)where o.type = 'U' and o.id = i.id and i.indid in (0,1)order by rows desc ,o.name 阅读全文