当我试图插入执行表时，我得到了那个错误。当我尝试插入更多行到 Employee_in 我出错了
表值构造函数中每行的列数必须相同

CREATE DATABASE EmployeeDatabase

USE EmployeeDatabase

CREATE TABLE Employee_In
(
    EmployeeID INT NOT NULL PRIMARY KEY,
    EmployeeName CHAR(30) NOT NULL,
    EmployeeCountry CHAR(30)NOT NULL,
    EmployeeSalary INT NOT NULL
)

USE EmployeeDatabase
GO

INSERT INTO Employee_In (EmployeeID, EmployeeName, EmployeeCountry, EmployeeSalary)
VALUES (1001, 'Sundar', 'USA', 125000),
       (1002, 'Satya', 'CANADA', 120000);

SELECT * FROM Employee_In

CREATE TABLE Transactions_ID
(
    TransactionID INT NOT NULL PRIMARY KEY,
    EmployeeID INT FOREIGN KEY REFERENCES Employee_In(EmployeeID),
    PostalDate VARCHAR(20) NOT NULL,
    Amount VARCHAR(40) NOT NULL,
    Description CHAR(25),
);

USE EmployeeDatabase
GO

INSERT INTO Transactions_ID (TransactionID, EmployeeID, PostalDate, Amount)
VALUES ('1001','1001','2020-04-07','20000')