O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Parameters and Variables

Stored procedures can be assigned parameters, which are read when the procedure is executed in much the same way as parameters for Access mdb queries.

Parameters

Unlike Access mdb queries, all parameters for stored procedures must be declared. In mdb queries, you simply needed to use a parameter to define it. For parameters’ data types, you can use the SQL Server data types described in Chapter 5, “Tables in Access Projects.”

Parameters are inserted after the name of the procedure and before the AS command, as shown in Figure 8-4. A parameter name starts with @. The data type is specified directly after the name. Where there is more than one parameter, they are separated by commas. All parameters can be enclosed together ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required