本文翻译自:Select n random rows from SQL Server table I've got a SQL Server table with about 50,000 rows in it.我有一个SQL Server表,其中包含大约50,000行。I want to select about 5,000 of those rows at random.我想随机选择大约5,000行。I
ALTER PROCEDURE [dbo].[usp_RandomNumber] ( @Len INT = 1, --随机数位数 @Rows INT = 1 --随机笔数 ) AS BEGIN DECLARE @T AS TABLE([Random Number] VARCHAR(MAX)) DECLARE @L INT = 1, @R INT = 1 WHILE @R <= @Rows BEGIN DECLARE @RN varchar(MAX) = '' WHILE @L <= @Len -...
Select a random row with Microsoft SQL Server: SELECT TOP 1 column FROM table ORDER BY NEWID() Select a random row with IBM DB2: SELECT column, RAND() as IDX FROM table ORDER BY IDX FETCH FIRST 1 ROWS ONLY Select a random record with Oracle: SELECT column FROM ( SELECT column FROM t...
SELECT x FROM correlated WHERE f1 = 0 AND f2 = 1 OPTION (QUERYTRACEON 4199, QUERYTRACEON 4137); Trace flags The following table lists and describes the trace flags that are available in SQL Server. Azure SQL Managed Instance supports the following global Trace Flags: 460, 2301, 2389, ...
Select a random row with Microsoft SQL Server: SELECT TOP 1 column FROM tableORDER BYNEWID() Select a random row with IBM DB2 SELECT column, RAND() as IDX FROM table ORDER BY IDX FETCH FIRST 1 ROWS ONLY ThanksTim Select a random record with Oracle: ...
select data_1.tid1,data_1.id from row_num as row_num inner join data_1 as data_1 on data_1.tid1 = row_num.tid2 最后轮到 POSTGRESQL , 但是这样做性能在大数据量上是一个问题。 select d.* from (select floor(random() * (max(id) - min(id))) as id from test_d) as ma ...
Random r =newRandom(0);stringinitialDataFile =".. \\.. \\UserIDLatLon.txt"; FileStream ofs =newFileStream(initialDataFile, FileMode.Create); StreamWriter sw =newStreamWriter(ofs);for(inti =0; i <1000000; ++i) {doublelat = (90.0- (-90.0)) * r.NextDouble() + (-90.0);doub...
VARIANT_TRUE:OLE DB Driver for SQL Server 會維護有效的資料列集。 DBPROP_ACCESSORDER R/W︰讀取/寫入 預設值:DBPROPVAL_AO_RANDOM 描述:存取順序。 必須在資料列集上存取資料行的順序。 DBPROPVAL_AO_RANDOM:資料行可以依任何順序進行存取。 DBPROPVAL_AO_SEQUENTIALSTORAGEOBJECTS:作為儲存物件繫結的資...
Declare @d DatetimeSet @d=getdate()SELECT top 1[ActivityID],[CardNo],[Password],[State],[CreateTime],NEWID() as RandomFROM [TGBus_Card].[dbo].[Ka_Card] WhereActivityID=501AndState=0Order By RandomSelect [语句执行花费时间(毫秒)]=Datediff(ms,@d,Getdate()) ...
Select Browse to locate your instance of SQL Server. The program is called sqlservr.exe. It's normally located at C:\Program Files\Microsoft SQL Server\MSSQL<VersionNumber>.<InstanceName>\MSSQL\Binn\sqlservr.exe. Select Next. On Action, select Allow the connection. Select Next. On Profile,...