Date Manipulation with DATEADD/DATEDIFF
Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.
2010-04-07
36,778 reads
Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.
2010-04-07
36,778 reads
In my last post, I noted that one of the biggest differences between ISNULL and COALESCE was the fact that...
2010-02-25
1,118 reads
One of the most common mistakes made in T-SQL is thinking that these behave identically. I've personally opened up a...
2010-02-04
3,941 reads
I see charindex used quite commonly in string manipulation. What I rarely see used is the optional third parameter. Here...
2009-12-21
2,926 reads
Tally (or numbers) tables are one of my favorite query writing tools. Such a simple premise that can be applied...
2009-12-17
3,185 reads
By Brian Kelley
In my YouTube subscriptions feed, a new video for the Azure Cloud Chronicles with...
By Steve Jones
This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
I have an Access database with a SQL backend with tables, views, SP's. I...
Good morning, Once again, I find myself Sr. DBA for a company. As I...
I'm experiencing odd behaviour when using Analysis Services as a data source in Excel...
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers