Wednesday, 28 October 2015

How to Find the last inserted record without using MAX / Top clause in SQL( Query).

1 : -
        Select *  From TABLENAME  Where  ID = IDENT_CURRENT('TABLENAME')

2 : -
        Set Rowcount 1
        Select * from TABLENAME   order by ID desc


No comments:

Post a Comment