SQLSERVER常用语句

1、获取当前连接的spid

select spid from [Master].[dbo].[SYSPROCESSES]

2、获取数据库信息

select * from master.dbo.sysdatabases

3、获取备份文件信息

RESTORE FILELISTONLY FROM DISK = ''

4、删除数据库

if exists(select * from master.dbo.sysdatabases where name='  ‘)
    drop database ’‘

5、枚举数据库

select name from master..sysdatabases order by name

6、判断列是否存在

 a、select 1 as flag where COL_LENGTH('table' , 'column') is not null

b、select 1 as flag where EXISTS (
    SELECT 1 FROM SYSOBJECTS T1 INNER JOIN SYSCOLUMNS T2 ON T1.ID=T2.ID
    WHERE T1.NAME='table' AND T2.NAME='column');

7、数据库中的用户对象

select [name] from sysobjects 
    where type='U' or Type='V' or type='P' or type='TF'