sql001

DECLARE @i INT;SET @i=1;
WHILE(@i<=333)	BEGIN 	 INSERT INTO _5rOffers(Title,OfferType,ClassID,ModelClassID,UserID,RegionID,Price,Offerdate)	
 VALUES(	 '供应'+CONVERT(NVARCHAR,@i),0, 11+cast(rand(checksum(newid()))*5 as int) ,	 29+cast(rand(checksum(newid()))*30 as int) ,	 76797,200+cast(rand(checksum(newid()))*3000 AS INT),999+@i,GETDATE())	 SET @i=@i+1;	
END

转载于:https://www.cnblogs.com/YoursLan/archive/2011/06/29/2093014.html