TSQL Queries – Using NTILE
NTILE is a SQL Server function that can be called in a TSQL Query. This is part of the free sql query training to prepare… Read More »TSQL Queries – Using NTILE
70-461 Training
SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs
The SQL Training was a lot of fun this week we covered Top, Ranking, NTILE, and Analytic functions in preparation for the Microsoft 70-461 exam. Next… Read More »SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs
TSQL Aggregation Crossword Puzzle
Based on this weeks Free SQL Server training on Aggregation, I have created a crossword puzzle with terms in the Aggregation session. Download the… Read More »TSQL Aggregation Crossword Puzzle
TSQL Aggregation Strategies and Aggregating Data
This weeks training as part of the Free SQL Training for the 70-461 certification course is now available on YouTube. This week we covered Aggregating… Read More »TSQL Aggregation Strategies and Aggregating Data
DATEFROMPARTS function in TSQL
SQL Server 2012 adds a new function called DateFromParts. This new function simplifies the creating of a DATE type in TSQL over the older ways of… Read More »DATEFROMPARTS function in TSQL
- « Previous
- 1
- 2
- 3