whether_fine.sql

图书馆系统建立

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