Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement