2000
- , . SQL, . , :
1. , , .
2. - , - - .
. , .
. , worker. , @wo_count ( ), :
select @wo_count = count (*) from worker
:
create procedure count_workers @wo_count int output
as
select @wo_count = count (*) from worker
create procedure count_workers @wo_count int output
, count_workers, , , - . @wo_count - int ( ). , .
,
select @wo_count = count (*) from worker,
@wo_count . output out . , . as . , as, .
SQL Server Enterprise Manager.
Stored Procedures (. 1). , SQL-, .
.1. Enterprise Manager
Type System, . , , , User Type.
New Stored Procedures Action, , (. 2).
|
|
, SQL-, :
CREATE PROCEDURE [PROCEDURE NAME] AS.
[PROCEDURE NAME] , .
. 2.
. SQL Server Query Analyzer, . Premier1 DB.
(. 3).
. 3. Query Analyzer c Count_workers
@worker_count. count_workers. @worker_count. Print .
, , .
, , , , . , , .
calc_wage_fcns (. 4).
. 4. Calc_wage_fcns
@avg_hrly_rate ( ) - @skill_type. real , . , , . alc_wage_fcns (. 5).
. 5. Query Analyzer c Calc_wage_fcns
, execute . ( ) , , , , . calc_wage_fcns @skill_type, . , @avg_wage.
. . , . , . , . . , , .
|
|
. , , .
. 6.
. 6. Calc_wage_fcns
, , :
@skill_type char (10) = null.
null , , , . , , - .
. 7.
. 7. Query Analyzer c Calc_wage_fcns
RETURN. , . , , ? RETURN . , . , , worker. , , . 8.
. 8. Calc_wage_fcns1
. max, , . . 9.
, RETURN .
. 9. Query Analyzer c Calc_wage_fcns1
, SQL-. 1 2 , .
. 1
@@CPUBUSY | |
@@IDLE | |
@@IO BUSY | / |
@@ PACKRECEIVED | |
@@PACKSENT | |
@@PACKET ERRORS | , |
@@TIMETICKS | , , |
@@TOTAL ERRORS | |
@@TOTAL READ | |
@@TOTAL WRITE |
. 2