create table on the fly with OUTPUT INTO, not allowed? RRS feed

  • Question

  • We can do SELECT * INTO #TmpTbl FROM Tbl.

    So I was thinking we can do something similar with OUTPUT, but it doesn't look like you can do that. All the examples I found do it where you first create the temp table or table variable and OUTPUT INTO it.

    Am I correct that you can't create temp tables on the fly with OUTPUT INTO?

    Thursday, September 13, 2012 2:53 PM


All replies