列出所有用户表Select Name From SysObjects Where XType='U' order By NameXType='U':表示所有用户表;XType='S':表示所有系统表;3.获取所有字段名 Select Name From SysColumns Where id=Object_Id('TableName')A. ...
代码1：查看sql的执行时间
SET STATISTICS PROFILE ON
SET STATISTICS IO ON
SET STATISTICS TIME ON
select * from Meeting;
SET STATISTICS PROFILE OFF
SET STATISTICS IO OFF
SET STATISTICS TIME OFF
...
