http://www.sqlservercentral.com/Content tagged T-SQL, Programming, Stored Procedures, ADO posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters. http://www.sqlservercentral.com/articles/Stored+Procedures/introductiontoadothecommandobject/535/2007/02/09http://www.sqlservercentral.com/articles/Stored+Procedures/introductiontoadothecommandobject/535/Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about? http://www.sqlservercentral.com/articles/Miscellaneous/introductiontotheadoconnectionobject/510/2006/05/26http://www.sqlservercentral.com/articles/Miscellaneous/introductiontotheadoconnectionobject/510/Are you using default values for your parameters? Using named parameters when you call the proc or passing the values by ordinal? Should you be? Andy thinks 6 out of 10 of our readers will agree with his point of view, we'll be a little more conservative and guess that 5 of out 10 will be closer. http://www.sqlservercentral.com/articles/Miscellaneous/defaultvaluesandnamedparametersforstoredprocs/882/2003/01/08http://www.sqlservercentral.com/articles/Miscellaneous/defaultvaluesandnamedparametersforstoredprocs/882/The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters. http://www.sqlservercentral.com/articles/Stored+Procedures/introductiontoadothecommandobject/535/2007/02/09http://www.sqlservercentral.com/articles/Stored+Procedures/introductiontoadothecommandobject/535/In three previous articles Andy has done a very basic introduction to the ADO connection, command, and recordset objects. In this wrap up article he talks about how to use the power of ADO client side filtering and disconnected recordsets, then adds some code which shows how to combine all the objects. ADO is not simple, but Andy has done a good job in limiting his dicussion to the things you REALLY need to know about ADO to get started. http://www.sqlservercentral.com/articles/Performance+Tuning/introductiontoadopart4combiningitall/537/2001/12/07http://www.sqlservercentral.com/articles/Performance+Tuning/introductiontoadopart4combiningitall/537/Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about? http://www.sqlservercentral.com/articles/Miscellaneous/introductiontotheadoconnectionobject/510/2006/05/26http://www.sqlservercentral.com/articles/Miscellaneous/introductiontotheadoconnectionobject/510/My ASP file doesn’t access my database." "I can’t connect to my database from my code." "I’m having problems calling and debugging stored procedures." These are some of the problems I hear every day as a Microsoft® developer support engineer. http://www.sqlservercentral.com/redirect/articles/249/2001/07/20http://www.sqlservercentral.com/redirect/articles/249/If you’re running database-intensive code from Visual Basic or ASP, stored procedures can give you a great speed boost. With ADO 2.1, one of the components that makes up MDAC, this technique is easier to implement than ever. http://www.sqlservercentral.com/redirect/articles/248/2001/06/29http://www.sqlservercentral.com/redirect/articles/248/