Home Dashboard Directory Help
Search

UPDATE with varchar(max) variable by Kancleris


Status: 

Closed
 as Fixed Help for as Fixed


2
0
Sign in
to vote
Type: Bug
ID: 660673
Opened: 4/13/2011 6:06:55 AM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

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.
Details
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
Sign in to post a workaround.