Multiple OUTPUT statements not supported by SQL Prompt 6.1

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

Multiple OUTPUT statements not supported by SQL Prompt 6.1

Postby chrisw13 » Tue Oct 29, 2013 6:49 pm

SQL 2008 SP3+ and above (and probably below) supports multiple OUTPUT statements, as long as the first one is OUTPUT INTO and the second is OUTPUT...

These statements are nice to allow OUTPUT INTO a table variable/temp table for further operations, and to OUTPUT to return a result set to the user (SSMS or data layer).

The following TSQL is valid and executes, but SQL Prompt 6.1.0.72 will not format throws the message "SQL Prompt was unable to complete this operation. Problem areas have been highlighted."


SELECT *
INTO #Tbl
FROM ( VALUES ( 0) ) AS tbl (fld)

--Deletes from #Tbl
--Returns #Tbl as a ResultSet
--Inserts back it into #Tbl
DELETE FROM #Tbl
OUTPUT DELETED.*
INTO #Tbl
OUTPUT DELETED.*
chrisw13
 
Posts: 3
Joined: Mon Jul 01, 2013 3:56 pm

Postby Manfred.Castro » Wed Oct 30, 2013 8:54 pm

Thank you for reporting this issue to us.
I was able to reproduce the behavior and have logged this issue in our bug tracking system under the internal reference number of SP-4910.
Unfortunately I am unable to provide a timeline for when this may be fixed.
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Postby Aaron Law » Thu Nov 07, 2013 10:27 am

The second output clause should now be supported in the latest release (6.1.0.88)
Aaron Law
 
Posts: 250
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software


Return to SQL Prompt 6

Who is online

Users browsing this forum: Aaron Law, TGftYLmjle and 1 guest