Need help with stored proc with parameters


  • I have a project and I need to figure out the stored proc for this query:

    select Inventory.Sname
    from Parts, Inventory, Shipments
    where Parts.Color = 'green' and Parts.Pno = Shipments.Pno and Shipments.Sno = Inventory.Sno

    How can I create a stored proc with parameters for  specific color?

    samedi 7 septembre 2013 16:37


Toutes les réponses