Visual InterDev

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