SELECT INTO fails when an Identity column with Clustered index is included in the Select list - by MSSales Dev

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 808483 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 11/13/2013 1:44:54 PM
Access Restriction Public


SELECT INTO statement fails when an Identity column which is also the Primary key is included in the SELECT list. 

This a very critical feature that most of existing code and SPs use. While using TOP function sometime helps solve this. This workaround is not consistent. In other words, the use of TOP sometime works and sometimes not. 

Sign in to post a comment.
Posted by Microsoft on 11/14/2013 at 9:50 PM
Thank you for letting us know about this issue.
The issue will be fixed for our SQL Server 2014 release.