为上面表写写入客户信息的存储过程，通过客户号和房间号写入预定信息的存储过程，通过房间号修改房间状态的存储过程，写入员工信息的存储过程，删除员工信息的存储过程，建立可以通过员工号或员工姓名或身份证号或员工电话查看员工信息的事务，查询房间状态是否入住来通过客户号和房间号写入预定信息

好的，我会根据您的要求进行回答。以下是您提出的各种存储过程和事务的详细说明。

1. 写入客户信息的存储过程：

CREATE PROCEDURE insert_customer_info
@customer_id INT,
@customer_name VARCHAR(50),
@customer_phone VARCHAR(20),
@customer_email VARCHAR(50),
@customer_address VARCHAR(100)
AS
BEGIN
INSERT INTO CustomerInfo(CustomerID, CustomerName, CustomerPhone, CustomerEmail, CustomerAddress)
VALUES (@customer_id, @customer_name, @customer_phone, @customer_email, @customer_address)
END

2. 通过客户号和房间号写入预定信息的存储过程：

CREATE PROCEDURE insert_reservation_info
@customer_id INT,
@room_id INT,
@check_in_date DATE,
@check_out_date DATE
AS
BEGIN
INSERT INTO ReservationInfo(CustomerID, RoomID, CheckInDate, CheckOutDate)
VALUES (@customer_id, @room_id, @check_in_date, @check_out_date)
END

3. 通过房间号修改房间状态的存储过程：

CREATE PROCEDURE update_room_status
@room_id INT,
@status INT
AS
BEGIN
UPDATE RoomInfo
SET RoomStatus = @status
WHERE RoomID = @room_id
END

4. 写入员工信息的存储过程：

CREATE PROCEDURE insert_employee_info
@employee_id INT,
@employee_name VARCHAR(50),
@employee_id_card VARCHAR(20),
@employee_phone VARCHAR(20),
@employee_address VARCHAR(100)
AS
BEGIN
INSERT INTO EmployeeInfo(EmployeeID, EmployeeName, EmployeeIDCard, EmployeePhone, EmployeeAddress)
VALUES (@employee_id, @employee_name, @employee_id_card, @employee_phone, @employee_address)
END

5. 删除员工信息的存储过程：

CREATE PROCEDURE delete_employee_info
@employee_id INT
AS
BEGIN
DELETE FROM EmployeeInfo
WHERE EmployeeID = @employee_id
END

6. 通过员工号或员工姓名或身份证号或员工电话查看员工信息的事务：

BEGIN TRANSACTION

SELECT *
FROM EmployeeInfo
WHERE EmployeeID = @employee_id OR EmployeeName = @employee_name OR EmployeeIDCard = @employee_id_card OR EmployeePhone = @employee_phone

COMMIT TRANSACTION

7. 查询房间状态是否入住来通过客户号和房间号写入预定信息：

CREATE PROCEDURE insert_reservation_info_by_room_status
@customer_id INT,
@room_id INT,
@check_in_date DATE,
@check_out_date DATE
AS
BEGIN
DECLARE @room_status INT

SELECT @room_status = RoomStatus
FROM RoomInfo
WHERE RoomID = @room_id

IF @room_status = 0
BEGIN
INSERT INTO ReservationInfo(CustomerID, RoomID, CheckInDate, CheckOutDate)
VALUES (@customer_id, @room_id, @check_in_date, @check_out_date)

UPDATE RoomInfo
SET RoomStatus = 1
WHERE RoomID = @room_id
END
ELSE
BEGIN
PRINT 'The room is occupied.'
END
END

以上是对您提出的问题的回答，希望能帮助到您。