题目:
单选题
你负责一个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积分>