Viewing 2 posts - 1 through 3 (of 3 total)
It seems you have to place 3 different actions in 3 different transactions where actions are pre-insert loggin, inserting and after-insert logging.
Or you can use savepoints in transactions, but it...
December 6, 2003 at 6:02 am
#484973
Instead of CAST(<datetime value> as int) you can use FLOOR(CONVERT(DECIMAL(19,9), <datetime value>)) or CEILING(...).
To change the front-end format you can use SET LANGUAGE ...
123123
December 6, 2003 at 5:46 am
#484972