Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Stored Procedures, ADO Rss

   Items 1 to 9 of 9   
 

Creating Functions for Stored Procedures

With the advent of so many new technologies in the Microsoft space, a DBA needs to learn more and more about many of them that aren't a part of SQL Server. Alex Grinberg brings us a technique he has used to create ADO functions for your stored procedures.  Read more...
By Alex Grinberg 2008/10/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,249 reads

Introduction to ADO - The Command Object

The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters.   Read more...
By Andy Warren 2007/02/09 (first published: 2001/12/18) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 39,457 reads

Introduction to the ADO Connection Object

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?   Read more...
By Andy Warren 2006/05/26 (first published: 2001/11/08) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 30,958 reads

Default Values and Named Parameters for Stored Procs

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.   Read more...
By Andy Warren 2003/01/08 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,152 reads

Introduction to ADO - The Command Object

The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters.   Read more...
By Andy Warren 2007/02/09 (first published: 2001/12/18) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 39,457 reads

Introduction to ADO Part 4 - Combining It All

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.   Read more...
By Andy Warren 2001/12/07 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,948 reads

Introduction to the ADO Connection Object

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?   Read more...
By Andy Warren 2006/05/26 (first published: 2001/11/08) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 30,958 reads

Troubleshooting ASP and ADO Errors

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.   Read more...
By Additional Articles 2001/07/20 | Source: Microsoft MSDN | Category: stored procedures
Rating:  Rate this |   Briefcase | 1,606 reads

Using Stored Procedures from ADO 2.1

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.   Read more...
By Additional Articles 2001/06/29 | Source: Microsoft MSDN | Category: stored procedures
Rating:  Rate this |   Briefcase | 1,757 reads
   Items 1 to 9 of 9   
 
Tags
t-sql (7)    
programming (6)    
miscellaneous (2)    
visual basic 6 (2)    
advanced querying (1)    
asp (1)    
performance tuning (1)