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
35,869 reads
Seth Phelabaum
Data Type Precedence and Implicit Conversions
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
IN and NOT IN
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
String Manipulation - CHARINDEX()
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 Table - Character Date Validation
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
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers