T-SQL: A Simple Example Using a Cursor
For more information on cursors, also take a look at the free SQL query training provided by Steve Stedman. Cursors are a feature of SQL Server… Read More »T-SQL: A Simple Example Using a Cursor
TSQL
Recursive Scalar Function in T-SQL
In my Common Table Expressions presentation the topic of recursion often comes up, but for scalar functions in T-SQL, it might not be as common.… Read More »Recursive Scalar Function in T-SQL
T-SQL DATEPART Explained
Here is a quick rundown on the T-SQL DATEPART function for SQL Server. DATEPART is used to pull a single part of a date/time element… Read More »T-SQL DATEPART Explained
Common Table Expression accepted for SQL Saturday 212 in Redmond WA
My Common Table Expression presentation was accepted for SQL Saturday 212 in Redmond WA. This is the session that I am the most familiar with,… Read More »Common Table Expression accepted for SQL Saturday 212 in Redmond WA
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
Rows and Range, Preceding and Following
SQL Server 2012 adds many new features to Transact SQL (T-SQL). One of my favorites is the Rows and Range enhancements to the over clause.… Read More »Rows and Range, Preceding and Following
T-SQL 2012 Procedure sp_describe_first_result_set
SQL Server 2012 adds a new stored procedure called sp_describe_first_result_set. This new procedure returns metadata for the result set returned from a query. The metadata is… Read More »T-SQL 2012 Procedure sp_describe_first_result_set
What twitter hash tags do you follow for SQL Server?
# The key to twitter is to follow the right hash tags. What hash tags do you follow related to Microsoft SQL Server? Here are… Read More »What twitter hash tags do you follow for SQL Server?
Happy Birthday SQL Server 2012
It has been a year since SQL Server 2012 released. There were some fun posts on Twitter about the SQL Server 2012 birthday or anniversary.… Read More »Happy Birthday SQL Server 2012
Using a SEQUENCE object to generate letters.
SQL Server 2012 introduces a new T-SQL object used to generate numbers, a SEQUENCE, similar to an identity column. You can think of a sequence as a take… Read More »Using a SEQUENCE object to generate letters.