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:一个表中是否存在某列
- 简单存储过程错误!救命啊!!
- [工作急求]在一句sql中不用游标多次更新同一记录
- 急!!win7旗舰版32安装sql2005开发版安装好后登陆不进去!!
- SQL语言里怎么做下列计算操作呢?
- 如何用SQL成批更新数据表内容?
- 如何在mssql2005中实现对系统目录进行即席更新?
- 急!!!!
- 急急..!*.MDF文件除了用SQL SERVER的Import功能加入后查看外,還有沒有其他辦法打開呀?
- 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 的书吧,也许你能了解得更多!