trigger when column update - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

trigger when column update

Author

Topic

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2009-10-30 : 12:46:41

create trigger mail on calllog
for update
if update(Priority) // error
begin
print 'here'
end

priority is the column in calllog
why this wont wrk??

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-10-30 : 13:00:26

Try

create trigger mail on calllog
~~for~~ AFTER update
if update(Priority)
begin
print 'here'
end

Jim

Everyday I learn something that somebody else already knew

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2009-10-30 : 13:06:22

noop !

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-10-30 : 13:45:36

This really looks like a syntax error

create trigger mail on calllog
After update
AS
if update(Priority) // error
begin
print 'here'
end

Jim

Everyday I learn something that somebody else already knew

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-10-30 : 14:41:49

[code]
create trigger mail on calllog
for update
AS
if update(Priority) -- error
begin
print 'here'
end[/code]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources