Blog
T-SQL: DATEADD and DATEDIFF Functions
Excerpt by Don Kiely
Date and time functions perform operations on date and time values to return a string, numeric, or date/time value.
This course excerpt was originally posted April 11, 2013 from the online courseware SQL Server 2012, Part 7 of 9: Introduction to T-SQL by Don Kiely
T-SQL: PATINDEX Function
Excerpt by Don Kiely
In a previous article we discussed the REPLACE and STUFF functions. This article takes a look at PATINDEX, which supports wildcard characters and other regular-expression-like features for a pattern search.
This course excerpt was originally posted April 09, 2013 from the online courseware SQL Server 2012, Part 7 of 9: Introduction to T-SQL by Don Kiely
The Decline of the IT Generalist
By Martin Schaeferle
Back in the good old days - say, 20 years ago - many small companies had what was considered an "IT generalist." They pretty much did everything.
This blog entry was originally posted April 08, 2013 by Martin Schaeferle
T-SQL: REPLACE and STUFF Function
Excerpt by Don Kiely
All programming languages include functions for manipulating strings. This article shows how to use REPLACE and STUFF, some of the most common ones in Transact-SQL.
This course excerpt was originally posted April 05, 2013 from the online courseware SQL Server 2012, Part 7 of 9: Introduction to T-SQL by Don Kiely