title: Retrieve last record of SQL Server table
body: <p>Here is the my problem: I have a SQL Server database called <code>emp</code>. It has an <code>employee</code> table (with <code>userid int</code> column). I need to retrieve the last record of the <code>userid</code> in <code>employee</code> table with increment userid value + 1. At the moment I did it on the my GUI. So how do I write a sql query for it?</p>