Hello,
I have application, where I use table result of stored procedure.
This worked fine, until some of recent actualization and now I can use only numeric result of stored procedure.
My setup is according to: MS SQL Server (Angular)
u
in result is just number:
It works fine on the SQL:
Numeric result indicates that the return type of the stored procedure is unknown.
Thank you for suggestion.
Issue was caused by usage of temp tables. I follower this blog and replaced temptable with Declared table type.
CREATE TABLE #temp (Col A type, ...
(doesn't work)
versus
DECLARE @temp TABLE (Col A type, ...
(does work)
