Home Forums SQL Server 2005 T-SQL (SS2K5) Return a value from a stored procedure RE: Return a value from a stored procedure

  • April 4, 2012 at 10:40 am

    #1469015

    Actually, I got this to work with no problem.

    ALTER PROC dbo.sp_GetMaxID (@MaxID INT OUTPUT)

    AS

    BEGIN

    SELECT @MaxID = max(ID) + 1 FROM tblFileWatchMaxID;

    END

    Use the same test code from my post above.