select year(createdate) 年,month(createdate) 月,count(1) from public_cms_arcwhere (userid in (select id from cms_admin where userid='392') or userid='392')group by year(createdate),month(createdate)order by year(createdate) desc,month(createdate) desc
1. set statistics time on go xxxx go set statistics time off 2. DECLARE @begin dateTime DECLARE @end dateTime SET @begin=getdate(); BEGIN xxxx end set @end=getdate(); SELECT datediff(ms,@begin,@end) as 'Elapsed Time' 3. 也可以设置Query-Query options
原文:SQL SERVER统计服务器所有的数据库(数据库文件).表(表行数).字段(各字段)等详细信息 USE STAT GO SET NOCOUNT ON IF EXISTS(SELECT 1 FROM SYS.TABLES WHERE TYPE='U' AND name='DBInfo') DROP TABLE DBInfo IF EXISTS(SELECT 1 FROM SYS.TABLES WHERE TYPE='U' AND name='ColumnsInfo') DROP TABLE