Z
zhshf
Unregistered / Unconfirmed
GUEST, unregistred user!
我的SQL语句如下：
create table pdist
(n integer not null check(n>0),
a numeric(4,3) not null check(a between 0 and 1),
chkvalue numeric(5,4) not null check(chkvalue between 0 and 1),
primary key (n,a));
建立之后，从SQL Explorer看这个表，
FIELDNAME TYPE LENGTH SCALE
N INTEGER 4 0
A SMALLINT 2 3
CHKVALUE INTEGER 4 4
请高手指点！
急！急！急！
create table pdist
(n integer not null check(n>0),
a numeric(4,3) not null check(a between 0 and 1),
chkvalue numeric(5,4) not null check(chkvalue between 0 and 1),
primary key (n,a));
建立之后，从SQL Explorer看这个表，
FIELDNAME TYPE LENGTH SCALE
N INTEGER 4 0
A SMALLINT 2 3
CHKVALUE INTEGER 4 4
请高手指点！
急！急！急！