Question

SQL server 已插入数据如何自动生成主键

Answer 1

ALTER TABLE TBDROP COLUMN RecnoPK; ALTER TABLE TBADD RecnoPK int identity(1,1) PRIMARY KEY;