, .
, , .
SQL Server .
. .
, , , , , , , , .
sp_, .
. - . , .
, . :
1. ;
2. .
, .
, #.
, , .
, .
, ##.
, , .
,
:
1. : . , sp_ . ;
2. . , , ;
3. . , , ;
4. . SQL, .
:
|
|
<_>::=
{ CREATE | ALTER } PROC [ EDURE ] _ [; ]
[(@_ _ ] [ VARYING ] [= default]
[ OUTPUT ] ] [,...n]
[ READONLY ]
[ WITH { RECOMPILE | ENCRYPTION }]
[ FOR REPLICATION ]
AS
SQL_onepap [...n]
.
sp_, #, ##, .
, , , , .
, ,
CREATE PROCEDURE .
, . . . , , .
, , , .
- , ( ).
, , , @.
, .
, .
, , SQL, . CURSOR , .. OUTPUT.
OUTPUT , . , .
OUTPUT , .
, OUTPUT .
, .
VARYING
OUTPUT, CURSOR. , .
DEFAULT , . .
|
|
, . . RECOMPILE .
FOR REPLICATION ,
encryption , , .
AS , .. SQL, . SQL, , .
RETURN.
:
DROP PROCEDURE {_> [,...n]}