General information
Forum:
Microsoft SQL Server
Environment versions
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.
Previous
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