UPDATE with varchar(max) variable - by Kancleris

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.


2
0
Sign in
to vote
ID 660673 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 4/13/2011 6:06:55 AM
Access Restriction Public

Description

When you have variable varchar(max) or nvarchar(max) and you assign it with UPDATE statment like @c = @c then SQL server disconnects you.
2005 and 2008 have the same issue.
Sign in to post a comment.
Posted by Microsoft on 8/2/2011 at 6:25 PM
Hello,
We have now fixed this bug in the next major version of SQL Server. Thanks for reporting the issue.

--
Umachandar, SQL Programmability Team
Posted by Microsoft on 4/14/2011 at 2:58 PM
Hello,
Thanks for reporting the issue. I can repro the problem. We will investigate further and let you know what we find.

--
Umachandar, SQL Programmability Team