Stored Procedures & Views |
If you're designing a SQL Server or Oracle database, you can create and engineer stored procedures and views. You can view and maintain them from your database's property page.
A stored procedure consists of a set of SQL statements and can have input and output parameters. The syntax for creating a stored procedure is:
CREATE PROCEDURE procedure_name [input and output parameters] AS
SQL Statements
Views consists of a single SQL statement that selects data. You can think of a view as being a 'virtual' table. The syntax for creating a view is:
CREATE VIEW view_name AS
Select Statement
The following example shows a SQL Server stored procedure called sp_GetClient. The text of stored procedures and views is maintained using Visual Case's SQL editor. Undock the SQL text to edit your SQL statements in a larger window.