Unit 7 Flashcards
a set of Transact-SQL (T-SQL) statements that is compiled and stored as a single database object for later repetitive use.
Stored Procedure
It is the equivalent of a subroutine and a function in other programming languages.
Stored Procedure
We can describe stored procedures as?
Composition, Functionality, Syntax
Stored Procedure is consist of what composition
A header and A body
defines the name of the stored procedure, the input and output parameters, and some miscellaneous processing options. You can think of it as an API (application programming interface) or declaration of the stored procedure.
header
contains one or more Transact-SQL statements to be executed at runtime.
body
The other way to change a stored procedure
Alter Stored Procedure
Stored procedures may contain up to ________input and output parameters
2,100
The maximum length of any identifier is _____characters.
128
The body of the stored procedure consists of one or more Transact-SQL statements. The maximum size of the body of the stored procedure is _______
128MB
An alternative way to send values from a stored procedure to the caller is to
Return Values
return value statement can be followed by an _______ value that can be read by the caller
Integer
limited to int data types, they are most often used to signal an error status or error code to the caller
Return Values
are defined at the end of a parameter definition, behind the data types.
Default Values
Types of stored procedures
User-defined
System
Extended
Temporary
Global temporary
Remote
CLR
