MSSQL数据库表格清单
释义 | SQL语句 | 其他 |
---|---|---|
当前数据库 | SELECT DB_NAME() | - |
所有数据库 | SELECT name FROM master..sysdatabases | - |
SELECT DB_NAME(N) | N为0,1,2,… | |
查询表名 | SELECT name FROM master..sysobjects WHERE xtype = ‘U’ | |
SELECT name FROM someotherdb..sysobjects WHERE xtype = ‘U’ | ||
查询列名 | SELECT name FROM syscolumns WHERE id = (SELECT id FROM sysobjects WHERE name = ‘mytable’) | 当前数据库 |
SELECT master..syscolumns.name, TYPE_NAME(master..syscolumns.xtype) FROM master..syscolumns, master..sysobjects WHERE master..syscolumns.id=master..sysobjects.id AND master..sysobjects.name=’sometable’ | 列出master..sometable的列名称 | |
获取版本 | SELECT @@version | |
当前用户 | SELECT user_name() | |
SELECT system_user | ||
SELECT user | ||
用户权限 | SELECT permission_name FROM master..fn_my_permissions(null,‘DATABASE’) | 当前数据库权限 |
SELECT is_srvrolemember(‘sysadmin’) | 当前用户权限 | |
列出DBA账户 | SELECT is_srvrolemember(‘sysadmin’) | 当前用户是否是管理员,是则返回1 |
选择第N行 | SELECT TOP 1 name FROM (SELECT TOP 9 name FROM master..syslogins ORDER BY name ASC) sq ORDER BY name DESC | 返回第九行 |
选择第N个字符 | SELECT substring(‘abcd’, 3, 1) | 返回c |
ASCII值-字符 | SELECT char(0×41) | 返回A |
字符-ASCII值 | SELECT ascii(‘A’) | 返回65 |
字符串连接 | SELECT ‘A’ + ‘B’ | 返回AB |
时间睡眠 | WAITFOR DELAY ‘0:0:5’ | 睡眠5秒 |