devaji123 (4/3/2013)
Hi,Use Select max(identity column name) from table name (data inserted table). In one of our scenario we used this it worked. Try this.
Vasu
When we have inbuilt function that replaces your query then why we used that.....
Sean is correct about this....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/