SQL存储过程分配宿舍实例

CREATE DATABASE DBStuManage
use DBStuManage

CREATE TABLE TBROOM
(
    ROOMID INT IDENTITY(1,1) primary key,
    RoomNumber INT ,
    RoomBedCount INT,
    studentID INT
)
select * from TBROOM

CREATE TABLE TBSTUDENT
(
    studentID int primary key identity(1,1),
    name NVARCHAR(50) NOT NULL,
    sex bit not null,
    birthday datetime not null,
    majorid int 
)
select * from TBSTUDENT

---

--USE [DBStuManage]
--