The solution for this write this line "SET FMTONLY OFF" in begin part of your Stored Procedure but it will not work in selecting data from another database.
Example : Create procedure SPname
as
SET FMTONLY OFF
Wednesday, September 19, 2012
The selected stored procedure returns no columns
The reason was, selecting from a temp table and EF can’t figure out the shape of the results at design time.
The solution for this write this line "SET FMTONLY OFF" in begin part of your Stored Procedure but it will not work in selecting data from another database.
Example : Create procedure SPname
The solution for this write this line "SET FMTONLY OFF" in begin part of your Stored Procedure but it will not work in selecting data from another database.
Example : Create procedure SPname
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment