Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2000
it will add the datetime on insert
but will the field be updated automatically in subsequent updates
>>I have a database which has many table with 'updatedon' field of datetime type. These are updated on the client side. I want then to be updated on the server through triggers. And possibly with only one procedure called by all the table.
>>
>>1> How can I dynamically find out the table contains updatedon field and its type.
>>2> Is there any globally called trigger called by every table in the database which will update the field.
>>
>>
>>Rajesh
>
>
>I use the simpler method of adding default code to the column: GetDate() and mark them as "not null".
>Therefore if the date value is not supplied in Update and Insert statements, the table automatically will insert the proper DateTime.
Précédent
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