Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-09 : 09:26:23
|
| Jack Vamvas writes "Is it possible to derive the date of an inserted record in SQL 7 without having column defined to pick up the date either through user insert or getdate(). Essentially, my problem is that I have historical data which we now want to datestamp , but rather then doing todays date we would like to insert the date the record was inserted?" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-09 : 10:06:50
|
| I dont think it is possible until you had stored the information of every insertion , updation in a seperate table (audit purpose).thts y its always a good idea to have additional columns like Datecreated, datemodified, Createdby, Modifiedby columns . -------------------------------------------------------------- |
 |
|
|
|
|
|
timestamp of an inserted record in SQL 7