Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Using parameters inside a SP

    Try the below:

    CREATE PROCEDURE Test

     @statusID int = 0

    AS

    DECLARE @select  as nvarchar(100)

    DECLARE @where as nvarchar(100)

    SET @select = 'select * from tblStatus'

    IF @statusid > 0

     SET @Where = '...

Viewing post 1 (of 2 total)