mysql/sql server: SELECT @@identity

Question

is there a difference in the way this functions between the two databases mysql and sql server:

SELECT @@identity

Answer 1

I prefer SCOPE_IDENTITY() in SQL Server to avoid issues with triggers.

Answer 2

Yes: Since that doesn't appear to be in the ANSI SQL standard, it is left to the DBMS vendor to roll their own methods.

mysql_insert_id()