create trigger tgr_xx on xx for insert as begin if(getdate() > 15号) //判断日期转换自己去写 begin rollback end end go类似这样
判断日期大于15号 (DATENAME(DAY,GETDATE()))>15
use instead of triggerhttp://technet.microsoft.com/en-us/library/ms175521(v=sql.105).aspx
大概这样:
create trigger tri_insert on table_name for insert as declare @dt datetime select @dt=dt from inserted --将插入记录的日期值赋值给变量@dt if datepart(dd,@dt)>15 print '日期过期,无法插入数据!' else insert into table_name select * from inserted
create trigger tgr_xx on xx
for insert
as
begin
if(getdate() > 15号) //判断日期转换自己去写
begin
rollback
end
end
go类似这样
判断日期大于15号
(DATENAME(DAY,GETDATE()))>15
大概这样:
create trigger tri_insert on table_name
for insert
as
declare @dt datetime
select @dt=dt from inserted --将插入记录的日期值赋值给变量@dt
if datepart(dd,@dt)>15
print '日期过期,无法插入数据!'
else
insert into table_name select * from inserted