Sybase and Microsoft implement stored procedures identically, as the following syntax shows:
CREATE PROCEDURE GET_NAME_USING_ID @nID int = 1, @outVar varchar(20) OUTPUT
SELECT @outVar = FIRST_NAME FROM CONTACT WHERE ID = @nID
Notice that the return value does not need to be a variable. In this case, if the SELECT statement is successful, a 0 is returned as the return value.