whether_fine.sql

来自「图书馆系统建立」· SQL 代码 · 共 9 行

CREATE PROCEDURE  Whether_Fine
(@stu_id)
AS
IF NOT EXISTS (SELECT * FROM fine WHERE stu_tip>0 AND stu_id=@stu_id)
BEGIN PRINT'无欠费'
   RETURN 0
END
SELECT stu_tip FROM fine WHERE stu_id=@stu_id
RETURN -10