tsqltutorials.com
T-SQL CASE Statement - Switch Logic - conditional logic - T-SQL (Transact SQL) Tutorials
http://www.tsqltutorials.com/case-statment.php
T-SQL Tutorials - TSQLTutorials.com. Tables, Columns, Rows. What is an index? The CASE Statement is used for evaluating a list of conditions to return a result. This T-SQL Expression begins with the keyword CASE. The CASE statement can be used in similar fashion to IF/ELSEIF, however the CASE statement is often much more readable in code. A CASE Statement can be used in the SELECT as well in other sections of a query such as WHERE, GROUP BY and ORDER BY. The CASE Statement has a few basic parts:. Using t...
tsqltutorials.com
T-SQL TOP Option - Limiting resultsets and queries - T-SQL (Transact SQL) Tutorials
http://www.tsqltutorials.com/top-option.php
T-SQL Tutorials - TSQLTutorials.com. Tables, Columns, Rows. What is an index? The TOP option is used for limiting the output of a query result set. The TOP SQL Statement is often used with the SELECT statement. TOP can either specify the number of rows to return, or the precentage of rows to return. The ORDER BY clause can be used successfully with the TOP option. In other words, the ORDER BY will be completed before the rows are limited. Using TOP with SELECT Statements. Example for returning 10 rows:.
tsqltutorials.com
T-SQL PIVOT Statement - Pivoting (Crosstab) Data From a Database Table - T-SQL (Transact SQL) Tutorials
http://www.tsqltutorials.com/pivot.php
T-SQL Tutorials - TSQLTutorials.com. Tables, Columns, Rows. What is an index? The PIVOT statement is used for changing rows into columns in a SQL Query (Crosstab). The PIVOT Statement is generally written in this form:. IN ( [Pivot Column Values]. Note: You must use brackets around each of the Pivot Column Values. Beginning Example - Example #1. This example will use the following table: SELECT. Country, Variable, VariableValue. Here is a resultset from the above SELECT query:. Dynamic PIVOT - PIVOT with...
tsqltutorials.com
T-SQL UNPIVOT Statement - Unpivoting (Normalizing) Data From a Crosstab Database Table - T-SQL (Transact SQL) Tutorials
http://www.tsqltutorials.com/unpivot.php
T-SQL Tutorials - TSQLTutorials.com. Tables, Columns, Rows. What is an index? The UNPIVOT statement is used for changing columns into rows in a SQL Query (Normalization). The UNPIVOT Statement is generally written in this form:. IN ( [UnpivotedCol1],[UnpivotedCol1],[UnpivotedCol3],etc. Note: You must use brackets around each of the Pivot Column Values. Beginning Example - Example #1. This example will use the following table: SELECT. Country, Sales, Expenses, Taxes, Profit. NEW Sealed MICROSOFT SQL Serve...
tsqltutorials.com
T-SQL INSERT Statement - Inserting (Adding) Data Into a Database Table - T-SQL (Transact SQL) Tutorials
http://www.tsqltutorials.com/insert.php
T-SQL Tutorials - TSQLTutorials.com. Tables, Columns, Rows. What is an index? The INSERT statement is used for inserting (adding) data to a table. This SQL Statement begins with the keywords INSERT INTO. There are two methods for inserting data into tables:. This first method specifies the columns into which, the corresponding values will be added. The Values and Columns must be in the same corresponding order that you specify them. INSERT INTO table name (column1, column2, column3 .). This example will ...
tsqltutorials.com
T-SQL WITH - Common Table Expressions - Temporary named result sets - T-SQL (Transact SQL) Tutorials
http://www.tsqltutorials.com/with-common-table-expressions.php
T-SQL Tutorials - TSQLTutorials.com. WITH - Common Table Expressions. Tables, Columns, Rows. What is an index? The WITH Common Table Expression (CTE) is used for creating temporary named result sets. The functionality was introduced in SQL Server 2005. This T-SQL Expression begins with the keyword WITH. Name of temporary resultset. Columns in result set. This example will use the following table: SELECT. Name, Position, Salary. Here is the resultset from the above SELECT query:. SELECT * FROM Developers.
tsqltutorials.com
T-SQL SELECT Statement - Retrieving Data From a Database Table - T-SQL (Transact SQL) Tutorials
http://www.tsqltutorials.com/select.php
T-SQL Tutorials - TSQLTutorials.com. Tables, Columns, Rows. What is an index? The SELECT statement is used for retrieving data from a table. This SQL Statement begins with the keyword SELECT. The results from the SELECT query is called the 'Resultset'. The SELECT Statement has two basic parts:. Following the 'SELECT' keyword will be the columns to be selected. Following the 'FROM' keyword will be the table to be selected from. Name, Position, Salary. Here is a sample resultset from the above SELECT query:.
mdxtutorials.net
Members, Cells, Tuples, Sets - MDX (Multidimensional Expressions) Language Tutorials
http://www.mdxtutorials.net/members-cells-tuples-sets.php
MDX Tutorials - MDXTutorials.net. Members, Cells, Tuples, Sets. Is a specific value in a dimensional hierarchy. In the below Geography hierarchy, Asia, Europe, North America, Canada, Mexico, United States, Boston, Chicago, Los Angeles and New York are all members, of the Geography hierachy. Date][Calendar].[2008].[Feb 2008]). Geography].[Continent].[Europe],[Date].[Calendar].[2008].[Feb 2008]). Is a collection of Tuples.
mdxtutorials.net
An MDX Identifer - MDX (Multidimensional Expressions) Language Tutorials
http://www.mdxtutorials.net/identifiers.php
MDX Tutorials - MDXTutorials.net. MDX Identifers in SSAS. Are the names of individual SSAS objects. Every object has an identifier. Cubes, Members, Hierarchies, Dimensions, etc, are all objects, and thus all require identifiers. In order to reference and object you use the MDX identifier. SELECT State.City.CHILDREN ON COLUMNS,. Measures.MEMBERS ON ROWS. You will have to use a delimited identifier if any of the following apply:. If the identifier name is a reserved word. Measures.MEMBERS ON ROWS.
tsqltutorials.com
T-SQL COALESCE - Replacing NULL values - T-SQL (Transact SQL) Tutorials
http://www.tsqltutorials.com/coalesce.php
T-SQL Tutorials - TSQLTutorials.com. COALESCE - Replacing NULL values. Tables, Columns, Rows. What is an index? Often when writing queries you may want to check for NULL values and replace them with a non-NULL value. The COALESCE function is a good canidate to use for this purpose. It allows you to check if a value is NULL and then replace that value with a static value, or with another column(s). The following are two example syntaxes of using the COALESCE Function:.