sp_highandlow.txt

来自「使用asp+sql编写的的各种程序案例」· 文本 代码 · 共 5 行

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