--------------创建cardInfo表
create table cardInfo
(
cardID nvarchar(20) not null,
curType money not null,
savingType nvarchar(50) not null,
openDate datetime not null,
openMonye money not null,
balance money not null,
pass nvarchar(6) not null,
IsReportLoss bit not null,
customerID int not null
)
alter table cardInfo
add constraint PK_cardID primary key(cardID)
alter table cardInfo
drop column openMonye
alter table cardInfo
ADD openMoney money not null
alter table cardInfo
alter column curType nvarchar(50) not null
alter table cardInfo
add constraint DK_savingType default('RMB') for savingType
alter table cardInfo
add constraint CK_openMoney check(openMoney>0)
alter table cardInfo
add constraint CK_balance check(balance>0)
alter table cardInfo
add constraint DK_pass default('888888') for pass
------问题语句
---问题简述表名:cardInfo;关键列savingType,pass,在创建表的时候为之前的两列添加了默认值
---在插入时,使用联合插入即insert into 表名 Select 值 union 插入数据,在有默认值得列插入default关键字,但是提示default关键字附近有错误
---在使用insert into 表名 values 值进行单条插入就没有问题
--------问题语句
insert into cardInfo
Select '1010 3576 1234 5678','活期',default,getdate(),'1000',default,0,1,'1000' union
Select '1010 3576 1212 1134','定期',default,getdate(),'1',default,0,2,'1'
----------------成功语句
insert into cardInfo values('1010 3576 1212 1134','定期',default,getdate(),'1',default,0,2,'1')
insert into cardInfo values('1010 3576 1234 5678','活期',default,getdate(),'1000',default,0,1,'1000'')
请各位大虾友情讨论