Friday, April 22, 2011

How to find the max identity value in an identity colum using sql server 2008

declare @val as int
select @val = IDENT_CURRENT('table_name')
print @val

No comments: