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)







      FROM dbo.table1

      WHERE [ID]=@ID