Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Content with tags
T-SQL
,
ADO
Items 1 to 14 of 14
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,301 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,483 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,985 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,165 reads
Generating HTML Tables
In this article Andy looks at one way you can separate your presentation code from your data when you generate HTML tables for simple reports. Lots of code examples so you can see how it works.
Read more...
By
Andy Warren
2002/08/05
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
5,837 reads
Performance Comparison: Data Access Techniques
Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.
Read more...
By
Additional Articles
2002/03/01
|
Source:
Microsoft SQL Home
|
Category:
performance tuning
Rating:
Rate this
|
Briefcase
|
2,695 reads
Reducing Round Trips - Part 2
Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!
Read more...
By
Andy Warren
2002/02/06
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
9,239 reads
XML Data Solutions
This sample is provided in conjunction with the MSDN Magazine article, "SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web." This article presents and compares five data access approaches, using a variety of technologies including ASP and ADO, XSLT, and DirectXML. Once built, the solutions are compared on the basis of their speed and efficiency.
Read more...
By
Additional Articles
2002/01/18
|
Source:
Microsoft MSDN
|
Category:
updategrams
Rating:
Rate this
|
Briefcase
|
2,786 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,483 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,953 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,985 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,871 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,900 reads
Missing Temp Tables
In part one of a two part article, Andy Warren challenges the readers of SQLServerCentral.com to solve a problem involving ADO and SQL Server. Are you up to the challenge?
Read more...
By
Andy Warren
2001/06/01
|
Source:
SQLServerCentral.com
|
Category:
sql puzzles
Rating:
|
Discuss
|
Briefcase
|
4,153 reads
Items 1 to 14 of 14
Tags
programming
(11)
stored procedures
(7)
visual basic 6
(6)
miscellaneous
(4)
performance tuning
(3)
basics
(2)
sql server 7
(2)
xml
(2)
.net
(1)
advanced querying
(1)
asp
(1)
database design
(1)
sql puzzles
(1)
updategrams
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.