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 |
|
jmendez
Starting Member
2 Posts |
 Posted - 2008-08-18 : 16:32:32
|
| Hello all,I am using mssql 2005 and have some customer information that has been collecting for the two years. Is there a way to retrieve the timestamp from these tuples even though the current schema does not have a date column?I would like to know the date that these rows were added to the DB.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-18 : 16:34:35
|
| There is no magic in SQL Server. If the schema doesn't store the information, then the data does not exist in the database.If you've got transaction log backups going back 2 years, then you could get the data from there. But that would be a nightmare.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
jmendez
Starting Member
2 Posts |
Posted - 2008-08-19 : 08:50:05
|
| I figured that, I just wanted to be sure about this since I am new to SQL Servers. One more thing, I am planning on updating the DB by inserting a new date column so that anything inserted from now on we can see the date it was submitted. When the new column is inserted, will the existing rows contain a null value or will they have the date that the column was inserted?Thank you all for the replies. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-08-19 : 08:59:21
|
quote:
Originally posted by jmendez
I figured that, I just wanted to be sure about this since I am new to SQL Servers. One more thing, I am planning on updating the DB by inserting a new date column so that anything inserted from now on we can see the date it was submitted. When the new column is inserted, will the existing rows contain a null value or will they have the date that the column was inserted?Thank you all for the replies.
Existing values would be NULLMadhivananFailing to plan is Planning to fail |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-19 : 09:45:11
|
quote:
Originally posted by madhivanan
quote:
Originally posted by jmendez
I figured that, I just wanted to be sure about this since I am new to SQL Servers. One more thing, I am planning on updating the DB by inserting a new date column so that anything inserted from now on we can see the date it was submitted. When the new column is inserted, will the existing rows contain a null value or will they have the date that the column was inserted?Thank you all for the replies.
Existing values would be NULLMadhivananFailing to plan is Planning to fail
when it is declared as nullable (which is default).Alternatively you could make it NOT NULL with a default value. |
|
|
|
|
|
|
|
|
Get Date From existing rows.