数据库新建表

if OBJECT_ID(N'tSeventyTwoRpt',N'U') is not null
begin
    print '表存在！'
end
else
begin
    print '表不存在！'
    CREATE TABLE [dbo].[tSeventyTwoRpt](
    [d_Date] [date] NOT NULL,
    [n_RescueCount] [int] NULL,
    [n_UnplanReturn] [int] NULL,
    [s_SuccessRate] [decimal](18, 4) NULL
) ON [PRIMARY]
end

看看我