By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,729 Members | 1,487 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,729 IT Pros & Developers. It's quick & easy.

convert oracle trigger to sql server

P: 2
CREATE OR REPLACE trigger test."ORG1"
before update of
"ID"
on test.ORG
for each row
begin
"CM".add_entry(
:old."ID"
,:new."ID"
);
end;
/
Feb 14 '08 #1
Share this Question
Share on Google+
4 Replies


amitpatel66
Expert 100+
P: 2,367
CREATE OR REPLACE trigger test."ORG1"
before update of
"ID"
on test.ORG
for each row
begin
"CM".add_entry(
:old."ID"
,:new."ID"
);
end;
/
Please explain what you want excatly?

Do you want to conver oracle trigger to sqlserver trigger syntax??
Feb 14 '08 #2

P: 2
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
Feb 14 '08 #3

amitpatel66
Expert 100+
P: 2,367
Thread moved to SQL SERVER Forum
Feb 14 '08 #4

ck9663
Expert 2.5K+
P: 2,878
Here's more info about TRIGGERS and how to create them.


-- CK
Feb 14 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.