Click to See Complete Forum and Search --> : SQL Stored Procedure Resources


ai3rules
03-27-2007, 03:06 PM
Hi all,

I've been trying to find a good source for SQL programming tutorials / info but have not been able to come up with anything that good. Perhaps I'm searching incorrectly.

My main goal is to be able to write stored procedures that will modify/add/delete etc from SQL Server 2005. I'd like to communicate with these SP's via .asp pages.

I would appreciate any helpful links.

Thank you,
Israel

russell
03-27-2007, 11:38 PM
well, if u r looking for books Amazon (http://www.amazon.com/s/ref=nb_ss_gw/002-0948095-6924833?url=search-alias%3Daps&field-keywords=sql+server+2005+stored+procedures) has a few.

as for web resources, check sqlmag.com, sqlteam.com

stored procedures are just regular t-sql batches, pre-compiled on the server. your asp should use the command object to execute them. i've posted many samples here on doing just that. here (http://www.w3schools.com/ado/ado_ref_command.asp) is a good reference on the command object.

be sure to check out MSDN (http://msdn2.microsoft.com/en-us/library/ms190669.aspx) stored procedure reference too.

ai3rules
03-28-2007, 03:35 PM
Thank you.