sp_highandlow.txt

ASP+SQL Server动态网站开发从基础到实践教程

CREATE PROCEDURE sp_HighAndLow
(@HighUser VARCHAR(30) OUTPUT,@LowUser VARCHAR(30) OUTPUT)
AS SELECT @HighUser=MAX(customerid) FROM customers
SELECT @LowUser=MIN(customerid) FROM customers