469,320 Members | 2,121 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,320 developers. It's quick & easy.

fetching a last record inserted from a table and updating it.

hi all,
i have a table with 3 columns,
a column with data char (53),
a column which stores date,
a column which stores time of insertion of record into the table.
I need to write a query which retrieves the last inserted record and update the first column which is having data with current timestamp.
the insertion is happening automaticly due to the execution of a job and the data is logged automatically,but i have to just keep on updating the last inserted row itself.plz let me know how to do it.
Jan 27 '15 #1
1 1362
12,516 Expert Mod 8TB
Retrieve the Max() insert date and use that to filter for that record.
Jan 27 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Carlos San Miguel | last post: by
3 posts views Thread by Mark | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.