ok, bueno encontre esto en mysql.com
Código:
IDENTITY = value
This variable is a synonym for the LAST_INSERT_ID variable. It exists for compatibility with other database systems. You can read its value with SELECT @@IDENTITY, and set it using SET IDENTITY.
pero si alguien tiene un ejemplo practico
Saludos