April 27, 2004 at 5:15 am
i dont have date column in the tables, but i want to retrieve records who are 1 month old from the database.
is it possible, how to do it.
Thanks in Advance.
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
April 27, 2004 at 5:40 am
I am pretty certain this is impossible. If anyone does know I would love to find out.
If it is just newly inserted records you are looking for you will need to add a date column and populate it with getdate() or such.
If it is changed records, then you will need a trigger to do the work for you.
April 27, 2004 at 5:46 am
iam using SQL-SERVER 2000,
i saw one post which had this option,but it was some 6 months, it said every inserted records make an entry in some system table, and we can get records by making a join with that system table..
lets hope so., becoz it is really needed
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
April 27, 2004 at 6:27 am
Pls Reply to My Q.?, T-SQL Experts, if i dont find the solution it will be like a problem to me..
even suggestions r welcomed ,i will try them.
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
April 28, 2004 at 12:42 am
Only place to get this information is from your DATA LOG files, good luck...
Look into some programs which provide this capability, I know several off hand but are not cheap. The applications read the flat file through parsing methods knowing the structural layout of the log files.
These applications let you view all back-end information about your data and create methods of tasks which work with the flat file (completely outside) of your database...
Remember to Normalize your data! Plan Ahead!
Coach James
April 28, 2004 at 2:20 pm
Bad database design is the real problem here and not a SQL Server limit. Look into adding audit columns for creation and modification dates.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply