Get primary key after insert statement

sql server
MySQL

INSERT INTO Table(Column1, Column2, Column3) VALUES(Value1, Value2, Value3);
SELECT @@IDENTITY