>>>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')
Thank you very much.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham