Update Last Record in SQL Server 2005

[Adithya Adi]

Table name: shift_Login
columns:ID, Username, TimeLogin, TimeLogoff

Username and password is Checked from another table.
1.ID is AutoNumber,
2.Username is taken from the login form directly(Text Box)
3.TimeLogin is taken (current time) from the button click

only one can login at a time.
user will logoff after all the process.

when logging out - TimeLogoff should be entered directly to the shift_login table(current time).

anyway TimeLogoff will be entered in the last row.

Can u please send me the query to update the last row in the table.

[gpl]

In the context of an SQL table, last row is meaningless

however, this should do what you ask

Select Max(TimeLogoff)
From shift_Login
 

[Adithya Adi]

thanks for the code.. its not that I meant.. but that was enough.. I got the idea to do from your code..
The code actually need for me was ------
"update ShiftLogin set shftlgn_time_off = 'xxxxxxxx' where shftlgn_empid = (Select Max(shftlgn_empid) From ShiftLogin)"