SQL Server 2005 中的多个随机值 [英] Multiple random values in SQL Server 2005

问题描述

我需要在 SQL Server 2005 下生成多个随机值，但不知何故这根本行不通

I need to generate multiple random values under SQL Server 2005 and somehow this simply wont work

with Random(Value) as
(
    select rand() Value
        union all
    select rand() from Random

)select top 10 * from Random

首选的解决方法是什么?

Whats the preffered workaround?

推荐答案

您是否尝试过类似的方法(可在 http://weblogs.sqlteam.com ) :

have you tries something like this (found at http://weblogs.sqlteam.com ) :

CREATE VIEW vRandNumber
AS
SELECT RAND() as RandNumber
GO

创建函数

CREATE FUNCTION RandNumber()
RETURNS float
AS
  BEGIN
     RETURN (SELECT RandNumber FROM vRandNumber)
  END
GO

然后你可以像往常一样在你的选择中调用它选择 dbo.RandNumber() , * from myTable

then you can call it in your selects as normal Select dbo.RandNumber() , * from myTable

或来自他们的评论:

select RAND(CAST(NEWID() AS BINARY(6))), * from myTable

这篇关于SQL Server 2005 中的多个随机值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！