Stored procedure
Ref:http://technet.microsoft.com/en-us/library/aa174792%28v=sql.80%29.aspx
A stored procedure is a group of Transact-SQL statements compiled into a single execution plan.
Microsoft® SQL Server™ 2000 stored procedures return data in four ways:
- Output parameters, which can return either data (such as an integer or character value) or a cursor variable (cursors are result sets that can be retrieved one row at a time).
- Return codes, which are always an integer value.
- A result set for each SELECT statement contained in the stored procedure or any other stored procedures called by the stored procedure.
- A global cursor that can be referenced outside the stored procedure.
SQL Table
A table is a collection of related data held in a structured format within a database. It consists of fields (columns), and rows.