mandmtech
asked on
insert trigger 2
Hi,
I'm getting an error with the following trigger. Please help!
ERROR: Incorrect syntax near '='.
Thanks
Create Trigger FSP_fullname
on members_mike
for insert
AS
SET FullName_ = ISNULL(rtrim(ltrim(ISNULL( FSP_First_ Name, '')) + SPACE(1) + ltrim(ISNULL(FSP_SurName, ''))),'READER')
FROM members_mike t
JOIN inserted i ON
t.memberid_ = i.Imemberid_
where members_mike.memberid_ = inserted.memberid_
I'm getting an error with the following trigger. Please help!
ERROR: Incorrect syntax near '='.
Thanks
Create Trigger FSP_fullname
on members_mike
for insert
AS
SET FullName_ = ISNULL(rtrim(ltrim(ISNULL(
FROM members_mike t
JOIN inserted i ON
t.memberid_ = i.Imemberid_
where members_mike.memberid_ = inserted.memberid_
ASKER
Sorry but I'm an SQL rookie. So in this case the SELECT will act as an SET, meaning it will update the fullname_ column??
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"So in this case the SELECT will act as an SET"
Yes, you can't SET from a table, you have to select
Yes, you can't SET from a table, you have to select
ASKER
Sorry, I missed the UPDATE
on members_mike
for insert
AS
SELECT FullName_ = ISNULL(rtrim(ltrim(ISNULL(
FROM members_mike t
JOIN inserted i ON
t.memberid_ = i.Imemberid_
where members_mike.memberid_ = inserted.memberid_