SELECT @@IDENTITY FROM MyTable;