!!!!!! Find the result set of stored procedure return !!!!!!!!!!!!!!!

lainomi

The query conditions are dynamically specified, that is: select field1, field2, field3 into #temp from testtable where 1 = 1 + dynamically pass the stored procedure judgment conditions (such as: and field1 = 2) How can I solve this problem? And then use: select * from #temp but at this time #temp has been invalidated, it is really a headache, please also give pointers to one or two.

endman

In the stored procedure select * from #temp
But at this time, we must ensure that this select statement is the only or at least the first executed statement in the stored procedure.

endman

Or, another way; you can write a function that returns a table
See the help example for specifics; it is clear.

endman

CREATE FUNCTION SalesByStore (@storeid varchar (30))
RETURNS TABLE
AS
if @storeid = ''
RETURN (SELECT title, qty
      FROM sales s, titles t
      WHERE s.stor_id = @storeid and
      t.title_id = s.title_id)
else if ...

abomination

I don't know what you are doing

exec('
select field1,field2,field3 from testtable where'+queryStr+'
')

yourapy

The stored procedure can directly return the result set of your choice, the temporary table is indeed redundant

lainomi

There is no desired answer.