query for new input

[biry]

i was wondering if i could be informed by a query, what items or values were inputed into the database yesterday.

thanks

 

[SQLSister]

Only if you are storing the record create date in your table. I almost always have a field for CreateDate, LastModifiedDate and ModifiedBy in my important tables. Then have the database fill these in automatically through default values or triggers. Then the query to see what was recently entered is a simple one with CreateDate = getdate()-1 in the where clause.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief