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