Back to list
Views:   11.8K
Replies:  2
Archived

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

http://support.microsoft.com/kb/306574


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

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

CREATE PROCEDURE sp_GetInventory
  @location varchar(10)
AS
SELECT Product, Quantity
  FROM Inventory
 WHERE Warehouse = @location

To call this Stored Procedure:  

EXECUTE sp_GetInventory 'FL'
For more information check this link: http://databases.about.com/od/sqlserver/a/storedprocedure.htm

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