The TSQL DATEPART Function
You can use the TSQL DATEPART function to extract individual parts of the date from a date or time item. For instance: Will return the… Read More »The TSQL DATEPART Function
SQL Server
Simple Introduction to TSQL Cursors
A cursor is a tool in SQL Server that allows a user to traverse through the rows of a result set one row at a… Read More »Simple Introduction to TSQL Cursors
Next Weekly Training: Functions (Logical Functions, Time Functions, and UDFs)
On Thursday March 19th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I to prepare for the Microsoft 70-461… Read More »Next Weekly Training: Functions (Logical Functions, Time Functions, and UDFs)
Today’s Live Training: Using Cursors and TSQL String Functions
Here is the outline: Using Cursors Using String Functions Here is the link to the Google On Air Broadcast where you can watch for free.… Read More »Today’s Live Training: Using Cursors and TSQL String Functions
Simple Cursor Example : FORWARD_ONLY vs FAST FORWARD
Here is our simple cursor example showing both FAST_FORWARD and FORWARD_ONLY cursors. A FAST_FORWARD cursor in SQL Server is a type of forward-only, read-only cursor… Read More »Simple Cursor Example : FORWARD_ONLY vs FAST FORWARD
TSQL OUTPUT Clause With UPDATE Statements
Earlier in the week I added a blog entry on using the OUTPUT Clause on INSERT Statements, today I will expand it by exploring the use of… Read More »TSQL OUTPUT Clause With UPDATE Statements
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
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