★★★快来抢300分★★★:在sql server里创建trigger时,怎么把表用参数表示出来??
deak 2002-01-09 02:48:58 如:
CREATE TRIGGER insertCity ON dbo.yellowpage
FOR insert AS
declare @id as decimal(18,9),
@code as char(5),@city as char(4),
@namesc as nchar(51),
@tel as char(20),
@im as char(2)
Begin
select @id=id,@code=type2, @namesc=namesc, @tel =TelNum1,@im=im,@city=city from inserted
insert into y@city (id,code,namesc,tel,im) values(@id,@code,@namesc, @tel ,@im)
end
其中y@city 为什么不能被识别为表的名称,怎样用@city 的参数表示为表的名称