  | 
			
				SoftTree Technologies 
				Technical Support Forums
			 | 
		 
		  | 
	 
	 
	
	
	
		
	
	
	
		| Author | 
		Message | 
	 
	
		
			gemisigo 
			 
			
  
			
			
				Joined: 11 Mar 2010 Posts: 2175
  | 
			 
			  
		 | 
		
			
				  [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
  | 
   
 
		 | 
	 
	  |