Friday, February 10, 2012

constant

How do you define a constant in a trigger?Hi,
Like a normal constant in stored procedure.
create trigger ins_tri on x for insert
as
begin
declare @.val int
set @.val = 1
insert into y(i) values(1)
end
Thanks
Hari
SQL Server MVP
" -00Eric Clapton" <a@.b.com> wrote in message
news:OfWRriZuFHA.464@.TK2MSFTNGP15.phx.gbl...
> How do you define a constant in a trigger?
>

No comments:

Post a Comment