T-SQL insert test returning Id of a new row

Insert with Id output

CREATE TABLE Customers
(
	Id		INT 			IDENTITY(1,1) NOT NULL,
	Name	NVARCHAR(255)	NOT NULL
);

GO

SET IDENTITY_INSERT Customers OFF;

CREATE PROCEDURE CustomerAdd
(
	@CustomerName NVARCHAR(255),
	@Id 		  INT OUTPUT
)
AS
BEGIN
	INSERT INTO Customers
		(Name)
	VALUES
		(@CustomerName);

	SET @Id = SCOPE_IDENTITY();
END;

GO

DECLARE @NewId INT
EXEC CustomerAdd 'Jimmy', @NewId OUTPUT
SELECT @NewId