CREATE TABLE stuInfo
(stuName NVARCHAR(20) NOT NULL,
stuNo NCHAR(6) NOT NULL,
stuSex NCHAR(4) NOT NULL,
stuAge SMALLINT NOT NULL,
stuSeat SMALLINT IDENTITY(1,1),
stuAddress NTEXT)
-- stuSeat 为 自增长标识,不需要手动插入值
insert into stuInfo values('mk','01','male',14,'lk');
insert into stuInfo values('mks','01s','mal',15,'lkds');
insert into stuInfo values('mkss','01s','male',18,'lkads');
select * from stuInfo
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/060828381f30e924c95b0e784f086e061c95f7f8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)