SQL Server 常用SQL(整理)

SQL Server与SQL Server Express的区别 https://www.cnblogs.com/jerry01/articles/1614859.html

1.sqlserver 查询所有表的记录数

select   a.name as 表名,max(b.rows) as 记录条数   from   sysobjects   a   ,sysindexes   b     
  where   a.id=b.id   and   a.xtype='u'   
group   by   a.name   
order by max(b.rows) desc

# 获取记录总数据 

SELECT
	SUM (记录条数) AS 记录条数
FROM
	(
		SELECT
			a.name AS 表名,
			MAX (b. ROWS) AS 记录条数
		FROM
			sysobjects a,
			sysindexes b
		WHERE
			a.id = b.id
		AND a.xtype = 'u'
		GROUP BY
			a.name
	) t

2.查询数据库版本信息 

 

sqlcmd -S 192.168.1.177 -U sa -P Fjtwkfb

1> SELECT @@VERSION
2> go

Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (Intel X86)  # 2008版显示内容

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) # 2008 R2版显示内容

 

3.SQLServer版本对应内部数据库版本

SQLServer版本对应内部数据库版本

源答SQL Server版本内 内部数据库版本
SQL Server 2016 852
SQL Server 2014 782
SQL Server 2012 706
SQL Server 2008 R2 665
SQL Server 2008 661
SQL Server 2005 with vardecimal enabled 612
SQL Server 2005 611
SQL Server 2000 539
SQL Server 7 515

查询SQLServer对应的内容部数据库版本号
select DATABASEPROPERTYEX('master','version')