Tag: temp table

SQL

How to insert results of a stored procedure into a temporary table

- 13.10.23 - ErcanOPAK comment on How to insert results of a stored procedure into a temporary table

CREATE TABLE #tmpTable ( COL1 int, COL2 int, COL3 nvarchar(max), COL4 nvarchar(max), COL5 bit ) INSERT INTO #tmpTable exec SpGetRecords ‘Params’ NOTE: The columns of #tmpTable must be the same as SpGetRecords. Otherwise, there will be a problem. If there are no parameters in the stored procedure, you don’t need to use ‘Params’.

Read More
ASP.Net WebForms / SQL

How to solve “TableAdapter can’t see stored procedure returned fields when using temp table” problem

- 06.06.18 | 22.11.19 - ErcanOPAK comment on How to solve “TableAdapter can’t see stored procedure returned fields when using temp table” problem

Add these lines to the beginning of your stored procedure. The statement is never executed, but for some reason it gets the job done. I really don’t know how and why 🙂 IF 1=0 BEGIN SET FMTONLY OFF END

Read More