>>I see. I think the second method (without GROUP BY, of course) is a correct method. The first one may return wrong value if that row was deleted.
>
>I see. So the IDENT_CURRENT() does not change if the last row is deleted. I didn't know that. Thank you.
Yes, I verifed it just in case
create table #temp (testID int identity (1,1), test varchar(10))
insert into #temp (test) values ('T1'),('T2'),('T3')
select IDENT_CURRENT('#temp')
delete from #temp where testID = 3
select IDENT_CURRENT('#temp')
If it's not broken, fix it until it is.
My Blog