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

Content with tags Stored Procedures, Programming Rss

<< Newer    Items 21 to 25 of 25   
 

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,605 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,756 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!   Read more...
By Additional Articles 2001/06/25 | Source: DevX | Category: stored procedures
Rating:  Rate this |   Briefcase | 2,327 reads

Executing Multiple Scripts in a Folder using the ScriptRunner Utility

Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.   Read more...
By Andy Warren 2001/06/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,581 reads
<< Newer    Items 21 to 25 of 25   
 
Tags
t-sql (18)    
miscellaneous (12)    
ado (6)    
sql server 7 (5)    
administration (4)    
sql-dmo (4)    
strategies (4)    
visual basic 6 (4)    
performance tuning (3)    
advanced querying (2)    
database design (2)    
security (2)    
asp (1)    
basics (1)    
best and worst practices (1)    
configuring (1)    
development (1)    
installation (1)    
naming standards (1)    
semaphore (1)    
sql puzzles (1)    
sql server (1)    
worst practices (1)