9
: .
: .
:
1. .
2. .
3. .
4. .
5. .
6. .
7. GO.
:
1. .
sp_help.
sp_help . , :
sp_help _;
sp_helptext.
() , sp_helptext:
sp_helptext _;
2. , , . Transact-SQL :
CREATE PROC [ EDURE ] procedure_name [; number ]
[{@parameter data_type } [VARYING] [=default ] [ OUTPUT ]]
[... n ]
[WITH { RECOMPILE | ENCRYPTION | RECOMPILE, ENCRYPTION} ]
[FOR REPLICATION ]
AS
sql_statement [... n]
:
procedure_name . sp_, # ##, . , , , , . , , CREATE PROCEDURE . USE.
Number , - .
parameter , . , @. ( 1024). .
data_type , . SQL Server, text, ntext image, . , cursor - , OUTPUT.
OUTPUT , . , . OUTPUT , . , OUTPUT . , .
|
|
VARYING , OUTPUT, cursor. VARYING , .
default , . , . , default.
RECOMPILE , . - . . .
FOR REPLICATION -. , FOR REPLICATION, , . . FOR REPLICATION RECOMPILE.
ENCRYPTION . , .
AS , Transact-SQL, . Transact-SQL, , . RETURN.
3. 10%( ):
CREATE PROC proc1
AS
UPDATE SET =*0.9
WHERE =
: EXEC proc1 proc1
DROP PROCEDURE ( ). . DROP PROCEDURE . DROP PROCEDURE :
DROP PROCEDURE __1, , __n
4. .
Transact-SQL , . Transact-SQL, , . , , , . , , .
|
|
, . , , , , . - .
, SQL-Server, .
5. GO . .
Transact-SQL,
, , , ,
. GO
USE,
, SELECT:
USE MyCompany
GO
SELECT * FROM Employee
GO
.
. , 30000 , .. .
: Sotrydnik Ludi. , . .
1. SQL Server Management Studio. Object Explorer Ludi - Programmability Stored Procedures.
2. dlastat1 Modify.
3. :
CREATE PROCEDURE dlastat1
OKL int
AS
BEGIN
SELECT * from Sotrydnik
Where Oklad>=@okl
END
GO
@OKL
int
.
SQL Server Management Studio. Object Explorer Ludi - Programmability Stored Procedures.
2. Stored Procedures New Stored Procedures.
3. , :
CREATE PROCEDURE calc
@first [int],
@sec [int],
Ret [int] output
AS
BEGIN
SET @ret=@first+@sec
END
GO
: , : sp_help sp_helptext.