Sql Store Procedure Dynamic Query Get Max Record

Dynamic Query Get Max Record Multiple table




CREATE PROC Get_Max_ID_SP (@tblName VARCHAR(50),@ClmnName VARCHAR(50))
AS
BEGIN


DECLARE @Qry NVARCHAR(MAX)
DECLARE @Ret NVARCHAR(MAX)
DECLARE @Param NVARCHAR(MAX)

SELECT @Param='@Val NVARCHAR(MAX) OUTPUT'
SELECT @Qry='SELECT @Val =ISNULL(MAX('+@ClmnName+'),0)+1 FROM ' + @tblName

    EXEC  SP_EXECUTESQL  @Qry,@Param,@Val=@Ret OUTPUT  
    
    SELECT @Ret as  MaxCust

END

Output :

exec  Get_Max_ID_SP 'DistMast','Distcode'

Result :

MaxCust

5

Reference Link:

    Create Store Procedure Insert, Update and Delete With Example : Click Me

    Create Store Procedure Search Record in Table : Click Me