抛出System.OutOfMemoryException类型的异常？ [英] Exception of type System.OutOfMemoryException was thrown?.

问题描述

自动将数据从datatable发送到表值函数。我发送id值大约1到10000行。我将id值传递给select查询中的表值函数。但它显示出内存异常。有一段时间它显示的页面加载连接被重置，就像它在asp.net中用c＃显示一样。请任何人帮助我。

autually i am sending the data from datatable to table valued function. i am sending the id values around 1 to 10000 rows. i am passing the id values to table valued function inside select query. but it showing out of memory exception. and some time it showing pageload connection is reset like it is showing in asp.net with c#. please anybody help me.

推荐答案

尝试

Try

select id from tbl_prod tp inner join table_valued_parameter tvp on tp.id = tvp.id 

这篇关于抛出System.OutOfMemoryException类型的异常？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！