27,579
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE t1
(
id INT DEFAULT LEFT(REPLACE(ABS(CHECKSUM(NEWID())),0,''),5),
name VARCHAR(20),
sex VARCHAR(2)
)
INSERT INTO t1 (name,sex)
SELECT '张三','男' UNION ALL
SELECT '李四','男' UNION ALL
SELECT '马娘娘','女'
SELECT * FROM t1
---------------------------
id name sex
21168 张三 男
14723 李四 男
26245 马娘娘 女
SELECT LEFT(REPLACE(ABS(CHECKSUM(NEWID())),0,''),5)
with t as (
select 11110 as id union
select 11121 )
select top 1 id from (
select top 99999
row_number()over(order by a.name) as id
from master..spt_values a ,master..spt_values b) t
where id>10000
and id not in (select id from t)
order by newid()