:
[ EXEC [ UTE ]] _ [; ]
[[@_=] { | @_ }
[ OUTPUT ] | [ default ] [,...n]
, EXECUTE .
, .
OUTPUT , OUTPUT .
DEFAULT, .
, DEFAULT , .
EXECUTE , . , .
, . , , .
, , . .
1. .
, .
CREATE PROC my_procl
AS
SELECT .,
.__*.
AS , .
FROM INNER JOIN ( INNER JOIN
ON .=.)
ON .=.
WHERE . = ;
:
EXEC my_procl my_procl
.
2. .
, , 10%.
CREATE PROC my_proc2
AS
UPDATE
SET __ = __*0.9
WHERE =
.
3. .
, .
CREATE PROC my_proc3
@k VARCHAR (50) /*
AS
SELECT .,
.__*.__ AS , .
FROM INNER JOIN ( INNER JOIN
ON .ID_ = .)
ON .ID_=.
WHERE .=@k
:
EXEC my_proc3 ''
|
|
m_ @k= '
4. .
%.
CREATE PROC my_proc4
@t VARCHAR (20), @p FLOAT
AS
UPDATE
SET __ = __ * (1-@)
WHERE = @t
:
EXEC my_proc4 '', 0.05
EXEC my_proc4 @t='', @p=0.05
5. .
%. .
CREATE PROC my_proc5
@t VARCHAR (20) = '',
@p FLOAT = 0.1
AS
UPDATE SET __ = __ * (l - @p)
WHERE = @t
:
EXEC my_proc5 '', 0.05
EXEC my_proc5 @t=, @=0.05
EXEC my_proc5 @p= 0.05
(.. ).
EXEC my_proc5
( , ) , .
6. .
, .
CREATE PROC my_proc6
@m INT,
@K FLOAT OUTPUT
AS
SELECT @K = Sum (. * .)
FROM INNER JOIN
ON .ID_=.
GROUP BY Month (.)
HAVING Month (.)=@m
:
DECLARE @st FLOAT