CREATE TABLE tb(id char(12))
--drop table tb
-- 创建用于自动过滤重复值的唯一索引
CREATE UNIQUE INDEX IX_tb ON tb(id)
WITH IGNORE_DUP_KEY
GO
-- 插入随机数据
SET NOCOUNT ON
DECLARE @row int
SET @row = 1000 -- 设置总记录数
WHILE @row >0
BEGIN
-- 显示提示信息, 表示还需要插入多行数据
RAISERROR('need %d rows', 10, 1, @row) WITH NOWAIT
-- 插入随机的位编码数据
SET ROWCOUNT @row
INSERT tb SELECT
id = RIGHT(1000000000000 + CONVERT(bigint, ABS(CHECKSUM(NEWID()))), 12)
FROM syscolumns c1, syscolumns c2
SET @row = @row - @@ROWCOUNT
END
GO
