convert oracle trigger to sql server

[helporacle9sql]

CREATE OR REPLACE trigger test."ORG1"
before update of
"ID"
on test.ORG
for each row
begin
"CM".add_en try(
:old."ID"
,:new."ID"
);
end;
/

[amitpatel66]

CREATE OR REPLACE trigger test."ORG1"
before update of
"ID"
on test.ORG
for each row
begin
"CM".add_en try(
:old."ID"
,:new."ID"
);
end;
/

Please explain what you want excatly?

Do you want to conver oracle trigger to sqlserver trigger syntax??

[helporacle9sql]

Please explain what you want excatly?

Do you want to conver oracle trigger to sqlserver trigger syntax??

yes i want to convert oracle trigger to sql server syntax

[amitpatel66]

Thread moved to SQL SERVER Forum

[ck9663]

Here's more info about TRIGGERS and how to create them.


-- CK