 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
[SA 7.1.246 Pro] - Assignment aligment bug? |
|
There are some anomalies with assignment alignment. Check the following piece of code:
 |
 |
UPDATE dbo.spt_monitor
SET lastrun = 1
,cpu_busy = 2
,io_busy = 3
; -- ;#1
UPDATE u
SET u.lastrun = 1
,u.cpu_busy = 2
,u.io_busy = 3
FROM
dbo.spt_monitor AS u
; -- ;#2
|
The first statement is properly assignment aligned on its own. However, having any statement following it it is not aligned properly unless ;#1 is present. Otherwise, it is not assignment aligned. Also, the seconds statement is not assignment aligned regardless of ;#2.
|
|
Fri Jan 23, 2015 9:57 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|