瀹為獙
7
瀛樺偍杩囩▼鍜岃Е鍙戝櫒鐨勪娇鐢?/p>
1.
瀛樺偍杩囩▼
鈶?/p>
鍒涘缓瀛樺偍杩囩▼锛屼娇鐢?/p>
Employees
琛ㄤ腑鐨勫憳宸ヤ汉鏁版潵鍒濆鍖栦竴涓眬閮ㄥ彉閲忥紝骞惰皟鐢ㄨ繖涓瓨
鍌ㄨ繃绋?/p>
USE
YGGL
GO
CREATE
PROCEDURE
TEST
@NU
MBER
int
OUTPUT
AS
BEGIN
DECLARE
@NU
MBER2
inT
SET
@NU
MBER2
=(
SELECT
COUNT
(*)
FROM
Employees
)
SET
@NU
MBER1
=
@NU
MBER2
END
鈶?/p>
鍒涘缓瀛樺偍杩囩▼锛屾瘮杈冧袱涓憳宸ョ殑瀹為檯鏀跺叆锛岃嫢鍓嶈�呮瘮鍚庤�呴珮灏辫緭鍑?/p>
0
锛屽惁鍒欒緭鍑?/p>
1
BEGIN
DECLARE
@SR1
float
,
@SR2
FLOAT
SELECT
@SR1
=
InCome
-
OutCome
FROM
Salary
WHERE
EmployeeID
=
@ID1
SELECT
@SR2
=
InCome
-
OutCome
FROM
Salary
WHERE
EmployeeID
=
@ID2
IF
@ID1
>
@ID2
SET
@BJ
=
0
ELSE
SET
@BJ
=
1
END