blocks|key|1379081|text|你能否提供一些细节，说明你计划如何使用这900万(%2B1)个数字？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1379082|如果唯一的目的是将一个数字流发送回客户端，那么在我看来，让客户机应用程序生成900万个号码就更有效了。|1379083|有许多方法可以根据少数几个较小的表的笛卡儿积(参见RMH的基-10示例)使用单个查询生成数字序列，但所有这些解决方案都需要：|1379084|首先，整个笛卡儿产品将建在tempdb中。|unordered-list-item|1379085|然后，对整个笛卡尔积进行排序(在内存和tempdb中)|1379086|只有到那时，所需的号码才会被发送回客户端。|1379087|无论您想要生成一个小的数字集(1到10)还是一组大的数字(1到9,000,000)，都需要对相同的“生成器”查询进行这种开销。|1379088|显然，需要使用一种更好、更高效、更轻量级的方法来防止占用数据服务器资源(例如，imaagine几个用户/应用程序试图生成9,000,000个数字.都使用了大量的tempdb空间以及cpu资源..。盖德..。期待来自DBA的愤怒的电子邮件/电话！)|1379089|另一个想法是使用循环构造来生成所需的数字.|1379090|declare+@counter+bigint,+@max+bigint
select+@counter=0,+@max=9000000
while+@counter+<=+@max
begin
++++select+@counter
++++select+@counter=@counter%2B1
end|code-block|syntax|javascript|1379091|..。虽然这将消除tempdb开销，但您仍然需要消耗少量的cpu资源，循环900万次。额外的性能影响可能来自生成900万1行结果集的开销，特别是您可能会看到过多的网络数据包在数据服务器和客户端应用程序之间流动。|1379092|虽然我们可以通过使最终结果看起来像单个结果集来减少网络数据包的数量，但这需要将上面的循环构造转换为存储过程，确保您已经定义了一个回送服务器，然后创建一个要引用的代理表，proc说；然后您将查询代理表以获得一个看起来包含所需的一组数字的结果集。|1379093|当然，在这一点上，我们现在必须跳过几圈，才能让数据服务器生成一系列数字(在某种程度上是有效的方法)作为单个结果集。|1379094|Sybase/ASE可以通过其他方法生成一系列数字(例如，创建/填充带有标识列的表)，但所有这些都需要一些良好的数据服务器资源，或者(+b)一些复杂的代码(例如，应用程序上下文函数，插件java代码).执行客户端/前端应用程序可能更有效地处理的事情。|1379095|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|18|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|19|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|1A|8|@]|9|@]|A|$]]|$1|I|3|J|5|H|7|1B|8|@]|9|@]|A|$]]|$1|K|3|L|5|H|7|1C|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1D|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1E|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1F|8|@]|9|@]|A|$]]|$1|S|3|T|5|U|7|1G|8|@]|9|@]|A|$V|W]]|$1|X|3|Y|5|6|7|1H|8|@]|9|@]|A|$]]|$1|Z|3|10|5|6|7|1I|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|1J|8|@]|9|@]|A|$]]|$1|13|3|14|5|6|7|1K|8|@]|9|@]|A|$]]|$1|15|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]]|16|$]]

Could you provide some detail as to what/how you plan to use those 9 million (+1) numbers?

If the sole purpose is to send a stream of numbers back to the client, it seems to me that it'd be much more efficient to just have the client application generate the 9m numbers.

<hr>

There are many ways to generate a sequence of numbers using a single query based on the cartesian product of a handful of smaller tables (see RMH's base-10 example), but all of these solutions require:

<ul>
<li>first, the entire cartesian product to be built in tempdb</li>
<li>then, the entire cartesian product to be sorted (in memory and tempdb)</li>
<li>and only then are the desired numbers sent back to the client</li>
</ul>

This overhead is required of the same 'generator' query regardless of whether you want to generate a small set of numbers (1 to 10) or a large set of numbers (1 to 9,000,000).

Obviously a better, more efficient, lightweight method needs to be used to keep from hogging dataserver resources (eg, imaagine several users/applications trying to generate 9,000,000 numbers ... all using large volumes of tempdb space as well as cpu resources ... egad ... expect an angry email/phone-call from the DBA!).

<hr>

Another idea would be use a looping construct to generate the desired numbers ...

<pre><code>declare @counter bigint, @max bigint
select @counter=0, @max=9000000
while @counter &lt;= @max
begin
 select @counter
 select @counter=@counter+1
end
</code></pre>

... and while this will eliminate the tempdb overhead, you're still going to use up a moderate amount of cpu resources looping 9 million times. An additional performance hit could come from the overhead of generating 9 million 1-row result sets, in particular you'll likely see an excessive number of network packets flowing between the dataserver and the client application.

While we could reduce the volume of network packets by making the final result look like a single result set, this would require turning the above looping construct into a stored procedure, making sure you have a loopback server defined, and then creating a proxy table to reference said proc; you would then query the proxy table to obtain what looks like a single result set containing the desired set of numbers.

'course, at this point we've now had to jump through a few hoops just to have the dataserver generate (in a somewhat efficient method) a series of numbers as a single result set.

<hr>

There may be some other means by which Sybase/ASE can generate a series of numbers (eg, create/populate a table with an identity column), but all will require either a) a good bit of dataserver resources or b) some convoluted code (eg, application context functions, plug-in java code) ... to do something that is likely more efficiently handled by the client/front-end application.

blocks|key|41747|text|在Sybase中，有一个可以用来生成数字的系统过程：行发生器|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|41748|你本可以这样做：|41749|+SELECT+row_num+FROM+sa_rowgenerator(+1,+9000000);|code-block|syntax|javascript|41750|我根本不知道Sybase+ASE，所以我搜索了它，发现这个过程在ASE中是不可用的，但是有一个替代方案：|41751|ASE不支持system系统过程sa_rowgenerator、sa_split_list和sa_conn_info。ASE主数据库包含一个表spt_values，该表可用于以类似于sa_rowgenerator过程或system的dbo.row_generator系统表的方式选择整数值。|blockquote|41752|来源：将SQL数据库应用程序迁移到ASE|41753|这个包含整数的表spt_values是难以置信的没有文档化。就像一张鬼桌。|style|CODE|41754|我建议你试一试：|41755|select+number+
FROM+master.dbo.spt_values
WHERE+number+BETWEEN+0+AND+9000000|41756|但如果你的数据库系统爆炸，我不负责;-)|41757|entityMap|0|LINK|mutability|MUTABLE|url|http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1540/doc/html/saiq-sa-rowgenerator-system-procedure.html|1|https://wiki.scn.sap.com/wiki/display/SQLANY/Migrating%2BSQL%2BAnywhere%2Bdatabase%2Bapplications%2Bto%2BASE^0|Q|4|0|0|0|0|0|0|3|H|1|0|8|A|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1B|8|@]|9|@$A|1C|B|1D|1|1E]]|C|$]]|$1|D|3|E|5|6|7|1F|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|1G|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|1H|8|@]|9|@]|C|$]]|$1|M|3|N|5|O|7|1I|8|@]|9|@]|C|$]]|$1|P|3|Q|5|6|7|1J|8|@]|9|@$A|1K|B|1L|1|1M]]|C|$]]|$1|R|3|S|5|6|7|1N|8|@$A|1O|B|1P|T|U]]|9|@]|C|$]]|$1|V|3|W|5|6|7|1Q|8|@]|9|@]|C|$]]|$1|X|3|Y|5|H|7|1R|8|@]|9|@]|C|$I|J]]|$1|Z|3|10|5|6|7|1S|8|@]|9|@]|C|$]]|$1|11|3|-4|5|6|7|1T|8|@]|9|@]|C|$]]]|12|$13|$5|14|15|16|C|$17|18]]|19|$5|14|15|16|C|$17|1A]]]]

In Sybase IQ, there's a system procedure that can be used to generate numbers: <a href="http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1540/doc/html/saiq-sa-rowgenerator-system-procedure.html" rel="nofollow noreferrer">sa_rowgenerator</a>

You could have done :

<pre><code> SELECT row_num FROM sa_rowgenerator( 1, 9000000);
</code></pre>

I don't know Sybase ASE at all, so I googled it and have found that this procedure isn't available in ASE, but that an alternative exists :

<blockquote>
 The SQL Anywhere system procedures sa_rowgenerator, sa_split_list, and
 sa_conn_info are not supported by ASE. An ASE master database contains
 a table, spt_values, that can be used to SELECT integer values in a
 way similar to that of the sa_rowgenerator procedure, or SQL
 Anywhere’s dbo.row_generator system table.
</blockquote>

Source : <a href="https://wiki.scn.sap.com/wiki/display/SQLANY/Migrating+SQL+Anywhere+database+applications+to+ASE" rel="nofollow noreferrer">Migrating SQL Anywhere database applications to ASE</a> 

This table <code>spt_values</code> containing integer numbers is incredibly NOT documented. It's like a ghost table. 

I suggest that you give this a try :

<pre><code>select number 
FROM master.dbo.spt_values
WHERE number BETWEEN 0 AND 9000000
</code></pre>

But I am not responsible if your database system explodes ;-)

I want to generate numbers from 0 to 9000000. In Oracle, I can use the below code. How do I do this in Sybase ASE?

This is in Oracle: 

<pre><code>SELECT level Num
FROM DUAL
CONNECT BY LEVEL &lt;= 9000000
ORDER BY Num;
</code></pre>

How to do this in Sybase ASE?

I cannot create a table and add an identity, because I need the numbers from 1 to 9000000, so a table will be complex. Is there a query to do this?

Sybase ASE connect by level equivalent

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我想生成从0到9000000的数字。在Oracle中，我可以使用以下代码。我如何在Sybase ASE中做到这一点？这是Oracle中的：SELECT level NumFROM DUALCONNECT BY LEVEL <= 9000000ORDER BY Num;如何在Sybase ASE中做到这一点？我不能创...

问Sybase ASE按电平等效连接
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Sybase ASE按电平等效连接EN