FILE: C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\110\Cartridges\sql70.xsl

--


	

	


	
	
	


	

	
	yes
	[
	]
	'
	'
	
	
	Microsoft SQL Server.07
  

	
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		TABLOCK,FIRE_TRIGGERS
		128
		128

		
		
			
				Provider
				
			
			
				Data Source
				Server
			
			
				Initial Catalog
				Database
			
			
				User ID
				UID
			
			
				Password
				PWD
			
			
				Integrated Security=SSPI
				Trusted_Connection=yes
			
		
	

	
		
		    System.Data.SqlClient
		    Microsoft.DataWarehouse.Design.SqlSchema, Microsoft.DataWarehouse
		    
			    Microsoft.DataWarehouse.Controls.SqlClientQueryDesigner, Microsoft.DataWarehouse
		    
		
		
		    System.Data.OleDb
		    Microsoft.DataWarehouse.Design.OleDbSchema, Microsoft.DataWarehouse
		    
			    Microsoft.DataWarehouse.Controls.OleDbQueryDesigner, Microsoft.DataWarehouse
		    
		
		
		    System.Data.Odbc
		    Microsoft.DataWarehouse.Design.OdbcSchema, Microsoft.DataWarehouse
		
	
	
	
	auto
	
	yes

	
	
		
			yes
			nosubsel
			no
		
	
	
	
	
	
	

	
	
		

			
			
				
			

			
			
				
					
						
							
								
									
										
									
								
							
						
						
							
								
									
										
									
								
							
						
					
				
			

			
			
				
					
						
							
						
						
							
						
						
							
						
					
				
			

		
	

	
	
		
			(
		
			
				
			
		
			)
		
	

	
	
		
			(
		
			
				
			
		
			)
		
	

	
	
		TOP () 
	

	
	
		
			(
		
		SELECT 
			
			
			
			
			
			
		
			
				 
			
		
			)
		
	

	
	
		UPDATE 
			
	

	
	
		INSERT INTO 
		
	

	
	
		DELETE FROM 
			
	

	
	
		DROP 
	

	
	
		CREATE 
		
			(  )
		
	

	
	
		OPENROWSET
		(
			,
			
				
					;;,
				
				
					,
				
			
			
		)
	

	
		DISTINCT
	

	
		 AS 
	

  FROM 


	
		
	

	
		GROUP BY 
	

	
		ORDER BY 
	

	
		WHERE 
	

	
		HAVING 
	

	
		
	

	
		
	

	
		=
	

	
		
		(
			
				
			
		)
		
			VALUES
			(
				
					
				
			)
		
	

	
		
		SET 
	

	
		
	

	
		
		
	

	
		
		
		
	

	
		
			
		
		
			
		
		
			
				
			
			
				
			
		
	

	
		DATABASE 
	

	
		
	

	
		TABLE 
	

	
		
	

	
		VIEW 
	

	
		
	

	
		INDEX 
	

	
		
		
	

	
		
	

	
		
		
			    primary key   
		
	

	
		
			(
		
		
		
			)
		
	

	
		
		
		
	

	
		ASC
	

	
		DESC
	

	
	
		
			
				
					
						@
					
					
						?
					
				
			
			
				
					
				
			
		
	

	
	
		DATEPART(  ,  )
	

	
	
		
		
			        year        
			     quarter     
			       month       
			   dayofyear   
			         day         
			        week        
			   weekday     
			        hour        
			      minute      
			      second      
			 millisecond 
		
	

	
	*

	
	
		
			
				 MIN 
				 MAX 
				 SUM 
			
		
		(  )
	

	
		COUNT (   )
	

	
	
	
		
			
							=		
							<>	
							>		
				=		]]>
								<	
						<=	
								IN		
								AND		
								OR		
								+		
							-		
							/		
							*		
			
		
		(
			
				
			
		)
	


	
	
	
		
			
							IS NULL		
			
		
		(
			
			
		)
	

	
	
		
		
			    nvarchar     
			    nvarchar     
			     varchar      
			    bit          
			      tinyint      
			      smallint     
			      int          
			      bigint       
			     tinyint      
			     smallint     
			     int          
			     bigint       
			      real         
			      float        
			    datetime     
			    datetime     
			      money        
			 sql_variant  
			 uniqueidentifier  
			 varbinary  
			 decimal      
		
		
		
				
	

	
	
	(  )
	
	
	
	
	( 
	

	
	
	,  )
	
	
	
		CAST( AS )
	
	
	
	
	

	
	 
		

		
			
		
		
			
		
		
			
		
		
			
				
			
			
				
			
		
	

	
	 
		

		
		
			
			
		
		
	

	
	 
		

		
		
			
			
		
		
	

	
	 
		
		

		
			
				
				
				
				
					
					
				
			
			
				
			
		
	

	
	
		
		
		
			
			
		
	

	
	
		
		

		
			
			
				
			
		
	

	
	
		

		
		
			
		
	

	
	
		

		
		
		
			
			
			
			CAST( AS bit)
			
			
			
			
			
			
			
			
			
			
			CAST(  AS datetime)
			CAST(  AS datetime)
			CAST(  AS money)
			
			
			
			
			NULL
		
	


--