Click here to Skip to main content
15,851,711 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
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.
Posted
Comments
CHill60 25-Nov-15 11:46am    
We'd need to see some code in order to help you
Member 12154439 25-Nov-15 11:58am    
sp : select id from tbl_prod where id in ( table valued paramerter)
coding i store the datatable to pass the sp .
ZurdoDev 25-Nov-15 12:37pm    
You have to simplify it. You're running out of memory. What can we do?
Aravindba 26-Nov-15 4:54am    
Try to pass 1 to 1000 values and check it work or not ,Actually "table valued paramerter" got 10000 values,so u pass one id to "table valued paramerter" for checking condition,so ur sql use more system memory.Check in internet how to increase sql memory or try to pass only 1000 records.
Philippe Mori 26-Nov-15 12:15pm    
Avoid showing more than 1000 rows. Big table are hard to use.

1 solution

Try
SQL
select id from tbl_prod tp inner join table_valued_parameter tvp on tp.id = tvp.id 
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900