select @@identity @@identity is global variable

How to Get the last identity value used

Question Posted / laxman

Answer Posted / laxman

select @@identity

@@identity is global variable

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain what is raid and what are different types of raid levels?

954

What does set rowcount do?

867

Why people hate cursor?

1096

What is sql server schema compare? How we can compare two database schemas?

962

List some advantages and disadvantages of stored procedure?

970

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

855

What is measure group, measure? : sql server analysis services, ssas

963

When to use null data driven subscription?

196

What are scheduled tasks in sql server?

1011

What do I need to start working with sql studio? : sql server management studio

1053

Explain the difference between clustered and non-clustered index?

872

How to list all user names in a database?

1005

How to count groups returned with the group by clause in ms sql server?

1008

what is unique and xaml nonclustered index

997

How to count duplicated values in a column in ms sql server?

999