-- 将多行记录(只能一个列)用指定分隔符分隔 IF(OBJECT_ID('sp_RowsChangeClosBySplit',N'P') IS NOT NULL) DROP PROC sp_RowsChangeClosBySplit GO CREATE PROC sp_RowsChangeClosBySplit ), -- 表名 ), -- 要拼接的字段 )=',', -- 分隔符 )='' -- 条件 AS BEGIN ) SET @sql='select TOP 1 stuff((sele
use information_schema; select concat(round(sum(DATA_LENGTH/1024/1024), 2), 'MB') as data from TABLES; select concat(round(sum(DATA_LENGTH/1024/1024), 2), 'MB') as data from TABLES where table_schema='dbname'; select table_schema,table_name,table_row
一.系统表 数据字典的详细信息请查SQL SERVER BOL,这里仅列出一部分. 1.1.sysservers 1.查看所有本地服务器及链接服务器 select * from master..sysservers 1.2.sysdatabases 1:查询非sa创建的所有数据库 select * from master..sysdatabases where sid not in(select sid from master..syslogins where name='sa') --或者 s