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     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.3.0