Thursday, June 6, 2013

IDENT_CURRENT vs TOP 1

How to get last inserted id in table

SELECT IDENT_CURRENT('clients')

select top 1 clientid from Clients order by 1 desc

No comments: