create trigger test1_insert on test1
for insert
as
if exist( select 1 from inserted where older1 > = 27 )
begin
raiserror ('yor are wrong',14,1)
rollback transaction
end
for insert
as
if exist( select 1 from inserted where older1 > = 27 )
begin
raiserror ('yor are wrong',14,1)
rollback transaction
end
解决方案 »
- 【优化】求助!!!查询数据问题,最好不要用游标
- 在sql server 2005里面怎么样垂直分区啊??急!!!!!!!!!
- 5000万行数据汇总查询 大约需要30分钟 请问建立索引后时间能缩短到多少?谢谢
- 已知結束日期、工作日天數,求開始日期
- 将表数据生成SQL脚本的存储过程,网上很多,但不知道怎么使用?!
- 统计某一用户在某一段时间内(一个星期或一个月)录单数,SQL语句如何写呢?
- 在SQL SERVER中有没有那个数据类型既可以存储文字又可以存储图片或声音的???
- 关于关系中函数依赖的问题
- 求SQL语句?50
- 取得server上时间的问题(急!!)
- SQL SERVER查询优化,连接(JION),OR,AND优化的原理!(有理者给分)
- 请问,怎么胖断一个表是否存在,用存储过程或SQL语句
create trigger test1_insert on test1
for insert
as
if exists ( select 1 from inserted where older1 > = 27 )
begin
raiserror ('yor are wrong',14,1)
rollback transaction
end
begin
raiserror ('yor are wrong',14,1)
rollback transaction
end
for insert
as
declare @a int
set @a=(select order1 from inserted)
if (@a >= 10500)
begin
raiserror ('yor are wrong',14,1)
rollback transaction
end
goif exists (select * from sysobjects where id = object_id('dbo.test1_insert') and sysstat & 0xf = 8)
drop trigger dbo.test1_insert
GOcreate trigger test1_insert on test1
for insert
as
if exists ( select 1 from inserted where older1 > = 27 )
begin
raiserror ('yor are wrong',16,1)
rollback transaction
end
go
if exists ( select 2 from inserted where older1 > = 27 )
or:
if exists ( select 'a' from inserted where older1 > = 27 )
or:
if exists ( select * from inserted where older1 > = 27 )毒一样.
还有以个不明白,"where id = object_id('dbo.test1_insert') and sysstat & 0xf = 8"这个指令有社么用呀?sysstat & 0xf = 8是哪里来的数值呀?sysstat和oxf是在哪里产生的?
很不错哦,很有耐心哦, elina(elina) ( 去看看SQL 的书吧,也许你能了解得更多!