摘要:
Declare @RandAry As Table( RandomInt Int)Declare @Count As IntDeclare @RandLoop AS Int = 0Declare @RandTotal As Int = 10Declare @RandNumber AS IntSelect @Count = Count(*) From dbo._cache_vLocationLookup(NOLOCK)While @RandLoop < @RandTotal Begin Set @RandNumber = Ceiling(Rand()*@Count) Insert Into 阅读全文