当前学科:未知科目
  • 题目: 单选题
    你负责一个SQL Server数据库。你需要只在当月第一天添加或修改表。你需要确保如果试图在其他某天修改或创建表,那么将出现错误,并且尝试将不成功。应使用哪一条Transact-SQL语句?( )

    • ACREATE TRIGGER TRG_TABLES_ON_FIRST ON DATABASE FOR
      CREATE_TABLE AS IF DATEPART(day,getdate())>1 BEGIN RAISERROR ('Must wait til
      next month.', 16, 1) END
    • BCREATE TRIGGER TRG_TABLES_ON_FIRST ON DATABASE FOR
      CREATE_TABLE, ALTER_TABLE AS IF DATEPART(day,getdate())>1 BEGIN RAISERROR
      ('Must wait til next month.', 16, 1) END
    • CCREATE TRIGGER TRG_TABLES_ON_FIRST ON DATABASE FOR
      CREATE_TABLE, ALTER_TABLE AS IF DATEPART(day,getdate())>1 BEGIN ROLLBACK
      RAISERROR ('Must wait til next month.', 16, 1) END
    • DCREATE
      TRIGGER TRG_TABLES_ON_FIRST ON ALL SERVER FOR ALTER_DATABASE AS IF
      DATEPART(day,getdate())>1 BEGIN ROLLBACK RAISERROR ('Must wait til next
      month.', 16, 1) END

    答案: <查看本题扣1积分>

    查看答案

    答案不对?请尝试站内搜索