CREATE TABLE Test1 (
ID INT IDENTITY(1,1) NOT NULL,
ID1 AS 'QX' + RIGHT(REPLICATE('0', 6) + CAST(ID AS VARCHAR),6),
Name VARCHAR(50),
PRIMARY KEY(ID)
ID INT IDENTITY(1,1) NOT NULL,
ID1 AS 'QX' + RIGHT(REPLICATE('0', 6) + CAST(ID AS VARCHAR),6),
Name VARCHAR(50),
PRIMARY KEY(ID)
)
说明:ID1列无需手动赋值,添加数据时会根据ID的变化而变化
例:当ID自增值为1时,ID1的值为QX000001