Link to home
Start Free TrialLog in
Avatar of mandmtech
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_
Avatar of Aneesh
Aneesh
Flag of Canada image

Create Trigger FSP_fullname
 on members_mike
 for insert
AS
SELECT 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_
Avatar of mandmtech
mandmtech

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
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"So in this case the SELECT will act as an SET"

Yes, you can't SET from a table, you have to select
Sorry, I missed the UPDATE