Stored procedures are known
under a variety of names: ASP users call them commands, whereas JSP developers know them as callables;
only ColdFusion users refer to them solely as stored procedures. Stored procedures are complete SQL
queries that may return recordsets or other data. Stored procedures are often used for complex data source
management such as inserting new tables on-the-fly.
Stored procedures are created and compiled in the data source itself, such as Microsoft??™s SQL Server.
Because they are precompiled, they execute faster than similar SQL statements entered directly into the Web
application. Stored procedures, like recordsets, can be defined as a data source through either the Bindings
panel or the Server Behaviors panel.
To define a stored procedure as a data source through the Server Behaviors panel, follow these steps:
1. From the Server Behaviors panel, click the Add (+) button and, depending on your server model:
for ASP, choose Command (Stored Procedure); for ColdFusion, choose Stored Procedure; and for
JSP, choose Callable (Stored Procedure). The stored procedure dialog box for the appropriate
server model is displayed; for example, Figure 34-22 shows the Command dialog box seen by
JSP users.
CROSS-REF CROSS-REF
1074
Extending Dreamweaver Part VII
FIGURE 34-22
Stored procedures must be included in the data source before they can be added as a data
source in Dreamweaver.
Pages:
1795
1796
1797
1798
1799
1800
1801
1802
1803
1804
1805
1806
1807
1808
1809
1810
1811
1812
1813
1814
1815
1816
1817
1818
1819