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(checks 阅读全文
posted @ 2011-06-29 10:23 我叫三炮 阅读(789) 评论(0) 推荐(0) 编辑