Many database applications do not rely exclusively on controls bound to tables or views in the database. Instead, they perform their data access via stored procedures or queries, which provides several advantages.
Using stored procedures can limit the changes made by users and can enforce validation and other requirements. If you work with queries, you can dynamically change the query as required by your application.
In this section, you can learn about how to create Microsoft® Visual InterDev™ applications that work directly with stored procedures and queries.
| To | See |
| Invoke a debugger for finding errors in Microsoft® SQL Server™ stored procedures | Debugging Stored Procedures and Triggers |
| Create recordsets using stored procedures or SQL queries that use a parameter filled in at run time. | Executing Parameterized Queries |
| Create, execute, and change SQL queries in script. | Executing Dynamic Queries |
| Call stored procedures and other database commands directly from script without using a Recordset design-time control. | Executing Database Commands Using the Data Environment |