Trouble great god help look at this statement have what problem, just learning it didn't take long for cooking chicken just didn't see
May be the brain w

CodePudding user response:

And try to use the trigger but On display there is an error

CodePudding user response:

The first question, from a list and you didn't write back (realwages)
Second question, you table associated conditions are not
Suggest add tables associated knowledge

 update a.c ol=biggest ol 
The from table1 as a left join table2 as b 
On Anderson, d=b.i d 

CodePudding user response:

The update, very convenient
The update @ tabSet set MatnrTypeID=b.M atnrTypeID, MatnrDes=b.M atnrDes from @ tabSet a inner join mdMatnr b on arjun atnrID=b.M atnrID

CodePudding user response:

The second question, in
CREATE the TRIGGER the front plus a go try:
Go
CREATE the TRIGGER XXX
Some statements to write separately