ssistutorial.com

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:.

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:.

tsqltutorials.com

T-SQL UNION - Joining two datasets together - T-SQL (Transact SQL) Tutorials

http://www.tsqltutorials.com/union.php

T-SQL Tutorials - TSQLTutorials.com. UNION - Join Data Sets. Tables, Columns, Rows. What is an index? Keyword in TSQL is used to combine two datasets. The two datasets must have the same number of columns in them and use the same datatypes. The datasets must also have the columns in the same comparative order. The UNION T-SQL Expression places the UNION. Factory Sealed - 228-04023 Microsoft SQL Server 2005 Standard Edition 5 CAL. Microsoft SQL Server 2016 Standard 10 Cal Part number 228-10602.

tsqltutorials.com

T-SQL CREATE TABLE Statement- Making new tables in SQL Server - T-SQL (Transact SQL) Tutorials

http://www.tsqltutorials.com/create-table.php

T-SQL Tutorials - TSQLTutorials.com. Tables, Columns, Rows. What is an index? The CREATE TABLE statement is how new tables are created in SQL. Tables are the structures that hold data, in a relational database. The syntax for using the CREATE TABLE command is as follows:. In this example we will create a simple 'Employees' table with a 'Name' column, 'Position' column and a 'Salary' column: CREATE TABLE Employees. EmployeeKey int IDENTITY(1,1) PRIMARY KEY,.