CREATE TABLE #t (id int IDENTITY(1,1) PRIMARY KEY,nums varchar(10))
INSERT INTO #t
SELECT 'BH'+cast(abs(CHECKSUM(NEWID())%100000) as varchar(8))
GO 10
INSERT INTO #t
SELECT 'BH'+cast(abs(CHECKSUM(NEWID())%100000) as varchar(8))
GO 10
自增长字段自定义
每天一进步、一积累，创造自我价值，体现人生逼格，你是自己的赢家!