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屋!