算术溢出错误
房磊 2011-07-10 08:15:35 将 expression 转换为数据类型 int 时出现算术溢出错误。
表结构如下:
create table cardInfo
(
cardID int primary key,
curType float not null,
savingType varchar(10) not null,
openDate datetime not null,
openMoney float not null,
balance float not null,
pass int not null,
IsReportLoss varchar(2) not null,
customerID int not null
)
go
--添加约束
alter table cardInfo
add constraint DF_openDate default(getDate()) for openDate
alter table cardInfo
add constraint CK_openMoney check(openMoney >=1)
alter table cardInfo
add constraint CK_balance check(balance >=1)
alter table cardInfo
add constraint DF_pass default(88888888) for pass
alter table cardInfo
add constraint DF_IsReportLoss default('否') for IsReportLoss
alter table cardInfo
add constraint CK_IsReportLoss check(IsReportLoss like '[是 否]')
alter table cardInfo
add constraint FK_customerID foreign key(customerID) references dbo.userInfo(customerID)