• Should you add OUTPUT AS

    CREATE PROCEDURE dbo.Create_Login

    (

    @username varchar(50) OUTPUT

    )

    AS

    ...

    ?