Need advice on Stored Procedures

[kcsilentbob]

I am trying to find a place on how to learn stored procedures. I am not even sure where to start or what program can be used to create them.

I have:

Crystal XI standard
MS Access 2000
MS VB 6.0

Can anyone point me in the right direction?

 

[ronspree]

Bob, if you have a copy of SQL Server, install Books Online (BOL) (installs by default). And for MS Access 2000, use SQL Server 7.0, or its desktop equivalent - MSDE 1.0 (included in your MS Office 2000). MS Access 2000 and MSDE 2000 (or SQL Server 2000) have compatibility problems when used together. If you really want to use MSDE 2000 (or SQL Server 2000), then upgrade to MS Access 2002 or higher.

One of the most significant advantage of MSDE 2000 over MSDE 1.0 is user-defined functions, which is not present in MSDE 1.0. But then, there are work-arounds.

Stored procedures can be created using Access itself, SQL Server's Query Analyzer, the DOS command line utility "osql" and "isql", or dynamically by code. There are also other utilities like the DbaMgr (free) which manages MSDE or SQL Server (including the creation or edit of stored procedures). Good luck.