ALTER procedure [dbo].[procMEDIAInsert]
@media_type int,
@description char(30),
@price float,
@date datetime
as
insert into MEDIA values(@media_type,@description,@price,@date)
declare @sql varchar(4000)
set @sql=+char(13)+'create trigger td_MEDIA on MEDIA '
+char(13)+'for insert,update '
+char(13)+'as'
+char(13)+'begin'
+char(13)+'if @price=(select media_type from inserted) and @media_type=(select price from inserted)'
+char(13)+' return 0'
+char(13)+'else '
+char(13)+' return 1'
+char(13)+'end'
-------编译是通过了 不过下面的把触发器赋值给存储过程的一个变量 貌似执行不到 有这种写法吗?正确的怎么写呢?
@media_type int,
@description char(30),
@price float,
@date datetime
as
insert into MEDIA values(@media_type,@description,@price,@date)
declare @sql varchar(4000)
set @sql=+char(13)+'create trigger td_MEDIA on MEDIA '
+char(13)+'for insert,update '
+char(13)+'as'
+char(13)+'begin'
+char(13)+'if @price=(select media_type from inserted) and @media_type=(select price from inserted)'
+char(13)+' return 0'
+char(13)+'else '
+char(13)+' return 1'
+char(13)+'end'
-------编译是通过了 不过下面的把触发器赋值给存储过程的一个变量 貌似执行不到 有这种写法吗?正确的怎么写呢?
一般人都不用你那种写法