I'm sure someone must have asked this before, but couldn't find it...
I have a stored procedure that is used to fill a .NET dataset (using an
SqlDataAdapter). The stored procedure also has a return value. The
resultant dataset contains many records that are selected in the sproc,
but I'm not sure what happens to the spocs return value. Can I get at
this value after filling the DataSet?
RE: Can we populate several tables in a .net DataSet using only one sp ... Assuming you are returning mutliple results sets from one stored procedure... You can modify or extract the code the wizard is generating and change the ... > Can we populate several tables in a .net DataSet using only one sp? ... (microsoft.public.sqlserver.programming)
Can we populate several tables in a .net DataSet using only one sp ... I have a .net DataSet that has 7 tables in a hierarchy structure.... populate this dataset using a stored procedure. ... Can we populate several tables in a .net DataSet using only one sp? ... (microsoft.public.sqlserver.programming)
Re: Performance issues with stored procedure ... Have you created a temporary table at the top of stored procedure?... Have you ran SQL Server Profiler to see what is going on when execute the ... > The proc is not very advanced, it involves creating a temp table, filling ... A couple of UDF's are used when filling the temp table. ... (microsoft.public.sqlserver.server)
Re: Performance issues with stored procedure ... > stored procedure especially 'Cach insert' event to make sure that a query ... >> The proc is not very advanced, it involves creating a temp table, filling ... A couple of UDF's are used when filling the temp table. ... >> Regards,... (microsoft.public.sqlserver.server)
