在C++中用SQL语句创建数据库表

_bstr_t sql = "IF NOT EXISTS(SELECT * FROM sysobjects WHERE id = object_id('alarms') AND type = 'U')\
            BEGIN\
            CREATE TABLE alarms\
            (\
                 alarm_id        int    default 1     NOT NULL,\
            alarm_datetime    datetime         NOT NULL,\
            alarm_status    int         NOT NULL,\
            CONSTRAINT    PK_OPERATORS    PRIMARY    KEY(alarm_id）\
             )\
            CREATE UNIQUE NONCLUSTERED INDEX IDX_OPERATOR_NO ON alarms(alarm_id) ";
pConnection->Execute(sql,&RecordsAffected,adCmdText);