A CREATE PROC (CREATE PROCEDURE) statement
The procedure name
The parameter list
The SQL statements
A stored procedure is a set of pre-defined Transact-SQL statements used to perform a specific task. There can be multiple statements in a stored procedure; all the multiple statements are clubbed into one database object.
The basic building blocks of a stored procedure include:
|
|
A CREATE PROC (CREATE PROCEDURE) statement |
|
|
The procedure name |
|
|
The parameter list |
|
|
The SQL statements |
Studio allows you to browse in a stored procedure directly from the tree structure. Specifically, you can expand the collapsed stored procedure to reach its components.
In the illustration below, you can see the stored procedures in the un-collapsed Stored Procedure folder in the database. The procedure "SQLCOLUMNS" is un-collapsed, allowing you to view its parameters and return values.
SQL Tree
|
|
|
|
|
Related Links: Viewing the Contents of a Table Data Display: Large Number of Results |
|
|
|
