Back to list
Views:   11.8K
Replies:  2

Stored Procedures

Where do I find information on using stored procedures with parameters instead of the inline sql statements?
Jonathan Patrick, Apr 16, 2010
Sorry, I should have been more clear. Is there examples on how to use stored procedures with parameters within the 'Db' class of the framework?
May 03, 2010
Reply 1
Good information on Stored Procedures is available in the following link

Chinna Srihari
Srihari Chinna, Apr 27, 2010
Reply 2
SQL statement :

SELECT Product, Quantity
  FROM Inventory
 WHERE Warehouse = 'FL'
Stored procedure:

  @location varchar(10)
SELECT Product, Quantity
  FROM Inventory
 WHERE Warehouse = @location

To call this Stored Procedure:  

EXECUTE sp_GetInventory 'FL'
For more information check this link:

I hope this helps.  

Redha Reghioua, Apr 25, 2010
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.