locked
SET FMTONLY ON RRS feed

  • Question

  • User-1090847506 posted

    hi,

    i am using SET FMTONLY ON for getting columns from query 

    but when i use #temp in query it gets error invalid object #temp

    is there any idea why this happens?

    Thursday, January 14, 2016 8:47 AM

Answers

  • User753101303 posted

    Hi,

    With FMTONLY the query doesn't run so the #temp table is not created and you can't query for column information or something like that...

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, January 14, 2016 4:01 PM