1 Reply Latest reply on Jan 5, 2017 8:46 AM by Dave Jobling

    Stored Procedure Steps

    Wendy Weber

      Can someone explain in detail the steps involved when creating and calling a stored procedure? I need to know how and where to click when creating a new stored procedure?  Where to add the parameter called "id" to pass to the procedure and where and how to call the procedure.  Detail explanations would be appreciated.

       

      CREATE PROCEDURE [dbo].[sample procedure]

      (

      @ID int(10)

      )

      AS

      (

      SELECT

      [id]

       

      FROM dbo.table1

      WHERE [ID]=@ID