Hi,

You can update you query in best way like below

Update TableA set a.col3=b.colc,a.col4=ColD,a.col5=ColE from TableA a, TableB b

Where b.ColA = a.Col1

Its similar like the join Query. Try This and...

Yes.

I did it for the Float Field.

Thank you for your suggestion.

Hi,

Trigger is mainly used for the situation when the db automeically trigger some events.

DML Triggers are,

Insert trigger,update trigger,delete trigger

Assume u write the delete trigger for your table.

whenever a row is...