SQL字符串，内存不足错误 [英] SQL String, out of memory error

问题描述

你好，

我需要一些代码，因为我从sql数据库的主表/明细表中获得了内存不足"错误.
MS SQL中没有Limit子句，该如何模拟呢?

请具体说明，我有一个包含PK FK的主表和一个带有PK FK的blob字段的明细.

无论在具有更大内存但仍在增加的系统中，blob字段测试的大小如何，而且还在增加，当我移至ado

Hello,

I need some code because of the "out of memory" error I get from a master/detail table in an sql database.
No Limit clause in MS SQL so how can I emulate it?

Please be specific, I have a master table with PK FK and a detail with a blob field with PK FK.

No matter the size of the blob field test in a system with larger memory but also was increasing, I need to get from the master table rows 5 at a time when I move to next record in ado

...position += 1

中的下一条记录并希望具有内部也要加入声明.

谢谢
Kyriakos

and want to have the inner join statment too.

Thank you
Kyriakos

推荐答案

out of memory exception ado.net dataset[^]

Have a read of this, but as everyone else has stated your being quite vague. If this doesn''t help update your question, make it more clear what you are after / trying to do and post a code snippet where the error is happen etc.

我已经输入了第二个数据适配器，并将fk作为参数，我从一个指向pt pk的文本框中获取值.

I have entered a second dataadapter and made the fk as a parameter which I take value from a textbox which points to the pt pk.

这篇关于SQL字符串，内存不足错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！