sqlserver 常用判断

1、判断数据库是否存在

select   1   from   master..sysdatabases   where   name='SWData'

2、判断表是否存在
select count(*) from sysobjects where id = object_id('swdata.dbo.天气实况')

3、创建数据库

CREATE DATABASE [SWData]  ON (NAME = N'SWData_Data', FILENAME = N'H:\SWData\SWData_Data.MDF' , SIZE = 13, FILEGROWTH = 10%) LOG ON (NAME = N'SWData_Log', FILENAME = N'H:\SWData\SWData_Log.LDF' , SIZE = 2321, FILEGROWTH = 10%)

 COLLATE Chinese_PRC_CI_AS

 GO