“将表达式转换为数据类型 int 时出现算术溢出错误”

我正在尝试执行简单的 SQL 代码来创建表。

BEGIN TRANSACTION;
CREATE TABLE vlan (vlanId int, vlanValue varchar(250), vlanName varchar(250), portId int, portName varchar(250), nodeId int, nodeName varchar(250));
INSERT INTO vlan VALUES(1111,998,'VOICE',7272,'1/97',456439345,'10.2.2.2');
.
.
.
.
INSERT INTO vlan VALUES(923482342,240,'INFODESK',2348328434,'4/46',2349234234,'10.1.2.3');
COMMIT;

它给出了错误：

Msg 8115, Level 16, State 2, Line 16164
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.
Msg 8115, Level 16, State 2, Line 16165
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.
Msg 8115, Level 16, State 2, Line 16166
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.

该表大约有。 16500 个元素。是不是因为文件太大了？

任何帮助都会有用的。

您的 vlanId 列对于数据类型来说太大int http://msdn.microsoft.com/en-us/library/ms187745.aspx（-2147483647 至 2147483647）。 使用bigInt http://msdn.microsoft.com/en-us/library/ms187745.aspx.

Link to SQL Server 文档。 http://msdn.microsoft.com/en-us/library/ms187745.aspx