关于SQL 查询数据库状态
下面这两条select 语句的执行效果不一样;
select name,physical_name,type,type_desc,state,state_desc from sys.master_files
select name,state,state_desc from sys.databases
select name,physical_name,type,type_desc,state,state_desc from sys.master_files
select name,state,state_desc from sys.databases