SQL: Strucktured Query Language

Get The Last Table ID from Inserted Data

SQL Server :

SELECT SCOPE_IDENTITY();
Example:
Insert Into Employees (LastName,FirstName) values ('Satrion','Rio');SELECT SCOPE_IDENTITY();

MySQL :

SELECT LAST_INSERT_ID()
 Example:
delcare blahblah int;
INSERT INTO blahblah (test1, test2) VALUES ('test1', 'test2');
SELECT LAST_INSERT_ID() INTO @blahblah;
INSERT INTO blahblah2 (test1, test2) VALUES ('test1', 'test2');
INSERT INTO blahblah3 (test1, test2, lastid) VALUES ('test1', 'test2', @blahblah);