See time records were inserted
up vote
0
down vote
favorite
I have a table with no time stamp in any of the columns.
With what I have now in the table and without inserting any rows or redoing everything, is there a way to see what time and / or date a record was inserted?
sql sql-server
add a comment |
up vote
0
down vote
favorite
I have a table with no time stamp in any of the columns.
With what I have now in the table and without inserting any rows or redoing everything, is there a way to see what time and / or date a record was inserted?
sql sql-server
Short answer: No.
– dnoeth
Nov 17 at 21:59
okay :( insert 8 more characters so I can send my sad emoji
– LunchBox
Nov 17 at 21:59
There are ways to parse the log to extract such information -- if the log is available from when the data was inserted.
– Gordon Linoff
Nov 17 at 23:07
Can you join your table data to any other data that does have a date, and was likely to be created around the same time? I had this recently with a db that didn't record the time a deposit identifier was created but did record when the deposit was made. In most cases these two events would be within minutes of each other so I was able to guess
– Caius Jard
Nov 17 at 23:15
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have a table with no time stamp in any of the columns.
With what I have now in the table and without inserting any rows or redoing everything, is there a way to see what time and / or date a record was inserted?
sql sql-server
I have a table with no time stamp in any of the columns.
With what I have now in the table and without inserting any rows or redoing everything, is there a way to see what time and / or date a record was inserted?
sql sql-server
sql sql-server
asked Nov 17 at 21:55
LunchBox
594317
594317
Short answer: No.
– dnoeth
Nov 17 at 21:59
okay :( insert 8 more characters so I can send my sad emoji
– LunchBox
Nov 17 at 21:59
There are ways to parse the log to extract such information -- if the log is available from when the data was inserted.
– Gordon Linoff
Nov 17 at 23:07
Can you join your table data to any other data that does have a date, and was likely to be created around the same time? I had this recently with a db that didn't record the time a deposit identifier was created but did record when the deposit was made. In most cases these two events would be within minutes of each other so I was able to guess
– Caius Jard
Nov 17 at 23:15
add a comment |
Short answer: No.
– dnoeth
Nov 17 at 21:59
okay :( insert 8 more characters so I can send my sad emoji
– LunchBox
Nov 17 at 21:59
There are ways to parse the log to extract such information -- if the log is available from when the data was inserted.
– Gordon Linoff
Nov 17 at 23:07
Can you join your table data to any other data that does have a date, and was likely to be created around the same time? I had this recently with a db that didn't record the time a deposit identifier was created but did record when the deposit was made. In most cases these two events would be within minutes of each other so I was able to guess
– Caius Jard
Nov 17 at 23:15
Short answer: No.
– dnoeth
Nov 17 at 21:59
Short answer: No.
– dnoeth
Nov 17 at 21:59
okay :( insert 8 more characters so I can send my sad emoji
– LunchBox
Nov 17 at 21:59
okay :( insert 8 more characters so I can send my sad emoji
– LunchBox
Nov 17 at 21:59
There are ways to parse the log to extract such information -- if the log is available from when the data was inserted.
– Gordon Linoff
Nov 17 at 23:07
There are ways to parse the log to extract such information -- if the log is available from when the data was inserted.
– Gordon Linoff
Nov 17 at 23:07
Can you join your table data to any other data that does have a date, and was likely to be created around the same time? I had this recently with a db that didn't record the time a deposit identifier was created but did record when the deposit was made. In most cases these two events would be within minutes of each other so I was able to guess
– Caius Jard
Nov 17 at 23:15
Can you join your table data to any other data that does have a date, and was likely to be created around the same time? I had this recently with a db that didn't record the time a deposit identifier was created but did record when the deposit was made. In most cases these two events would be within minutes of each other so I was able to guess
– Caius Jard
Nov 17 at 23:15
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
Well, you can create a trigger in this table which when you insert, it will insert another record in another (or update another to count the times that it is inserted) table with the date and all the information that you want.
Creating a trigger which controls the inserted records is explained in another question in stackoverflow, I leave you the link here:
Trigger: How does the inserted table work? How to access its rows?
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
Well, you can create a trigger in this table which when you insert, it will insert another record in another (or update another to count the times that it is inserted) table with the date and all the information that you want.
Creating a trigger which controls the inserted records is explained in another question in stackoverflow, I leave you the link here:
Trigger: How does the inserted table work? How to access its rows?
add a comment |
up vote
0
down vote
Well, you can create a trigger in this table which when you insert, it will insert another record in another (or update another to count the times that it is inserted) table with the date and all the information that you want.
Creating a trigger which controls the inserted records is explained in another question in stackoverflow, I leave you the link here:
Trigger: How does the inserted table work? How to access its rows?
add a comment |
up vote
0
down vote
up vote
0
down vote
Well, you can create a trigger in this table which when you insert, it will insert another record in another (or update another to count the times that it is inserted) table with the date and all the information that you want.
Creating a trigger which controls the inserted records is explained in another question in stackoverflow, I leave you the link here:
Trigger: How does the inserted table work? How to access its rows?
Well, you can create a trigger in this table which when you insert, it will insert another record in another (or update another to count the times that it is inserted) table with the date and all the information that you want.
Creating a trigger which controls the inserted records is explained in another question in stackoverflow, I leave you the link here:
Trigger: How does the inserted table work? How to access its rows?
edited Nov 18 at 2:45
answered Nov 18 at 2:38
Nikasha Von carstein
386
386
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53355919%2fsee-time-records-were-inserted%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Short answer: No.
– dnoeth
Nov 17 at 21:59
okay :( insert 8 more characters so I can send my sad emoji
– LunchBox
Nov 17 at 21:59
There are ways to parse the log to extract such information -- if the log is available from when the data was inserted.
– Gordon Linoff
Nov 17 at 23:07
Can you join your table data to any other data that does have a date, and was likely to be created around the same time? I had this recently with a db that didn't record the time a deposit identifier was created but did record when the deposit was made. In most cases these two events would be within minutes of each other so I was able to guess
– Caius Jard
Nov 17 at 23:15