SQL 随机生成30条数据 

 1 IF OBJECT_ID('tempdb.dbo.#tmp', 'U') IS NOT NULL
 2   DROP TABLE dbo.#tmp;
 3 GO
 4 CREATE TABLE #tmp (id UNIQUEIDENTIFIER,Iphone VARCHAR(50),PerID INT,addShop INT,name VARCHAR(50))
 5 DECLARE @id int,@sc int,@maxs INT =1,@houname VARCHAR(200),@Iphone VARCHAR(50),@PerID INT,@addShop INT
 6 SET @id=0
 7 SET @sc =30 --插入客户的数量
 8 WHILE @id<@sc 
 9 BEGIN
10 SET @PerID=(SELECT TOP 1 id FROM agent_config..mt_per_tbl WHERE DEPT_ID=246 AND del=1 order by newid())--随机某区用户ID
11 SET @addShop=(SELECT TOP 1 per_shop FROM agent_config..mt_per_tbl WHERE id=@PerID AND del=1)
12 SET @houname='客户'+CAST(@id AS VARCHAR(20)) ;
13 SET @Iphone=(SELECT 13000000000+cast( floor(rand()*1000000000) as bigint)+ABS(CAST(CAST( NewID() AS BINARY(3) )AS INT))) --更新新的电话
14 
15 --SELECT @Iphone,@houname,@addShop,@PerID INSERT #tmp
16 INSERT #tmp SELECT NEWID(),@Iphone,@PerID,@addShop,@houname
17 SET @id=@id+1
18 END
19 
20 
21 SELECT * FROM #tmp

 

posted @ 2022-03-15 14:16  SDdemon  阅读(279)  评论(0)  编辑  收藏  举报