随机生成六位纯数字ID编号的SQL语句 ======================================= DECLARE @RANDID INT SET @RANDID = 0 WHILE LEN(@RANDID)<>6 BEGIN SET @RANDID = CONVERT ( INT, SUBSTRING( CONVERT( CHAR(20) , RAND()) , 3, 6 ) ) END PRINT @RANDID
[原创][MS-SQL] 随机生成六位纯数字ID编号的SQL语句
最新推荐文章于 2024-04-21 20:52:22 发布