stu_information.sql

图书馆系统建立

CREATE PROCEDURE stu_information
(@stu_id int)
AS
SELECT stu_id,stu_name,sex_contain,spe_contain,stu_date,stu_state_contain,stu_edu
FROM stu_info,sex,speciality,stu_state WHERE
[stu_info].[sex_id]=[sex].[sex_id] AND [stu_info].[spe_id]=[speciality].[spe_id] AND [stu_info].[stu_state_id]=[stu_state].[stu_state_id]
RETURN 0