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.
2007-02-09 (first published: 2001-12-18)
39,990 reads
Stored Procedures
Using Stored Procedures for SQL Server DML
Designing your application so that Stored Procedures are the only database objects that are accessed is generally the best practice. Agree? Disagree? Read this article by guest columnist Mindy Curnutt to see what she thinks!
2001-08-01
12,752 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.
2001-07-20
2,008 reads
Using Stored Procedures in SQL Server
If you’re a programmer, you know that SQL is becoming more and more prevalent. Here’s a guide to one of its basic building blocks the stored procedure.
2001-07-09
4,417 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.
2001-06-29
1,967 reads
Automate Writing Stored Procedures
This article by David Rabb from the June 2001 issue of VBPJ shows you how to build a tool that will build a select, insert, update, and delete stored procedure for each table in a database. It's a great example of how to use DMO and a great tool as well!
2001-06-25
2,561 reads
Using XP_FILEEXIST
XP_FILEEXIST gives you the ability to find files and directories. Find out how else you can use it in this article.
2001-06-08
20,509 reads
Blogs
Free SQL Practice: 9 Killer Resources to Boost Your Query Skills
So, you want to get your SQL skills razor-sharp without dropping any cash? You're...
DevOps Devour Hour Slides
By Steve Jones
Here are the slides from my talk today at the Redgate NYC Devour Hour:...
Advice I Like: Take Two Trips
By Steve Jones
If you have any doubt about being able to carry a load in one...
Forums
Is there an ISERROR equivalent in SS?
Hi everyone I have a SP that just failed. Format of SP is: Select...
Analyzing Tempdb Spills and Usage Across Recursive Queries
Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...
Creating a new API in Data API Builder
Comments posted to this topic are about the item Creating a new API in...
Question of the Day
Creating a new API in Data API Builder
If I run "dab init" to create a new API over a database, what parameters are required?
See possible answers