SELECT @st
, ( 9).
7. .
, , .
, .
CREATE PROC my_proc7
@n VARCHAR (50),
@f VARCHAR (50) OUTPUT
AS
SELECT @f = _
FROM WHERE =@n
, , .
8.
CREATE PROC my_proc8
@fam VARCHAR (20),
@kol INT OUTPUT
AS
DECLARE @firm VARCHAR (20)
EXEC my_proc7 @fam, @firm OUTPUT
SELECT @kol = Sum (.__)
FROM INNER JOIN
ON .ID_=.
GROUP BY ._
HAVING ._ = @firm
:
DECLARE@k INT
EXEC my_proc8 '', @k OUTPUT
SELECT @k
9. , .
1.
CREATE myproc9
@name varchar (20)
AS
SELECT ._, SUM (.-__) , SUM (_)
FROM INNER JOIN
ON .id-=.
GROUP BY ._,.,.
HAVING .=@name and
.=(SELECT CONVERT (varchar(10), GETDATE (),120))
2.
CREATE myproc9
@name varchar(20)
AS
SELECT ._, SUM (.-__) , SUM (_)
FROM INNER JOIN
ON .id-=.
GROUP BY ._,.,.
HAVING .=@name and
.=(SELECT CAST (YEAR (GETDATE ()) AS CHAR (4))+-+ CAST (MOUNTH (GETDATE ()) AS CHAR (2))+-+ CAST (DAY (GETDATE ()) AS CHAR (2)))
( 2)
I) :
1. ;
2. ;
3.
(,
a. , );
b. _ ) .
4. ;
5. .
II) :
1
1. %:
|
|
CREATE PROC my_procl
@ FLOAT,
@iz VARCHAR (20)
AS
UPDATE SET =*(l+@p)
WHERE =@iz
.
EXEC my_procl 0.2, 'ACT
EXEC my_procl @p=0.2, 'ACT'
EXEC my_procl @='', 0.2
EXEC my_procl @iz='ACT', @p=0.25
2. , , :
CREATE PROC my_proc2
@f VARCHAR (20),
@iz VARCHAR (20),
@S FLOAT OUTPUT
AS
SELECT @s = SUM (. * .)
FROM INNER JOIN
ON .=.
GROUP BY ., .
HAVING .=@f AND .=@iz
.
DECLARE @st FLOAT
EXEC my_proc2 @iz='',@s=@st, @f='BaHOB'
SELECT @st
DECLARE @st FLOAT
DECLARE Of VARCHAR (20), @iz VARCHAR (20)
EXEC rny_proc2 @£='',@iz=M',@s=@st OUTPUT
SELECT @st
DECLARE @st INT
EXEC my_proc2 (', '', @st OUTPUT)
SELECT @St
DECLARE list FLOAT