SET NOCOUNT ON; Insert Into MY_TABLE (...) values (...) ; SET NOCOUNT OFF; SELECT SCOPE_IDENTITY() id