数据库相关语法记录

1.SQL Server

1.1 查询所在数据库所有表的行数

USE [dbname]
SELECT a.name, b.rows

FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id

WHERE (a.type = 'u') AND (b.indid IN (0, 1))

ORDER BY a.name,b.rows DESC

1.2 参数定义

USE [dbname]
DECLARE @i INT
DECLARE @device INT
DECLARE @sql VARCHAR(MAX)
SET @sql=''
SET @i=0
SET @device=47
WHILE @i<2
BEGIN
	SET @sql= @sql + 'select * into  ChannelData_' + CONVERT(VARCHAR,@device)+'_'+CONVERT(VARCHAR,@i)
	        + ' from ChannelData_' + CONVERT(VARCHAR,@device)+ '_' + CONVERT(VARCHAR,@i)
	        + ' where CollTime > ''2018-02-03 02:00:00.000'''
	SET @i=@i+1
END
PRINT (@sql)
EXEC (@sql)
GO