var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Before Trigger
I am anew SQL Server User.
I am trying to write a trigger using "Before".
The trigger is the following:
CREATE TRIGGER Insertintocity BEFORE UPDATE on [dbo].[stksz]
declare @City char(3)
declare @Code char(20)
select @Code = [stkszcd] from stksz
select @City = [stkszdes] from stksz
if not exists (select [regdes] from [region] where [regdes] = @city)
insert region (regcode, regdes)
print 'No City was added'
I am gettinthe following Error:
Server: Msg 170, Level 15, State 1, Procedure Insertintocity, Line 1
Line 1: Incorrect syntax near 'BEFORE'.
As I could see it, is that my server doesn't have before as a reserved word.
So can any one help me, it's a little bit urgent.
To be more clear, I want to use before because without before, the code is not always beeing correct.
Please help me in this.