General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Create a calculated field
I would like to create a calculated field that is based on 2 other fields in a table. The table is included in a database.
For example.
I have 2 fields lets say numerics with data in them.
I add a third field to my table.
Everytime someone updates one of the first 2 fields i'd like the third field to change also.
for simplicity lets say Field1 x Field2 = Field3
3 x 2 = 6
Whats the best way to do this, would I utilize the update trigger and a stored procedure?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only