2013-07-31 (first published: 2008-07-15)
1,595 reads
2013-07-31 (first published: 2008-07-15)
1,595 reads
2008-09-18 (first published: 2008-07-15)
697 reads
2008-09-10 (first published: 2008-07-12)
1,497 reads
2008-07-11
424 reads
How many times have you wanted to know which child or grandchild records exists for a parent record? SSMS doesn't make this information easy to find beyond one level. New author Narasimhan Jayachandran brings us an article and a recursive solution.
2008-07-10
12,288 reads
This objective of the article is to give readers in depth understanding of INNER JOIN with different joining conditions.
2009-10-23 (first published: 2008-07-08)
43,126 reads
2008-07-07
5,048 reads
Longtime author Leo Peysakhovich brings us a new article on error handling when you have procedures nested inside each other.
2008-07-07
9,313 reads
Alex Kozak returns with another Date puzzle. A question from a Simple-Talk reader gives Alex the inspiration to see if is possible to list unused date ranges in one Select statement.
2008-07-03
3,048 reads
Many times people come across the Coalesce function and think that it is just a more powerful form of ISNULL. In actuality, I have found it to be one of the most useful functions with the least documentation. In this tip, I will show you the basic use of Coalesce and also some features you probably never new existed.
2008-07-03
7,361 reads
By Kevin3NF
Does skipping a DBA save money? Wait until your system grinds to a halt,...
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...
I am in the process of migrating from MySQL to SQL Server. I have...
I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as...
Good morning to all. I am a novice when it comes to SQL so...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers