2013-05-17 (first published: 2010-09-22)
11,235 reads
Larry Gonick
2012-02-28 (first published: 2010-10-20)
9,595 reads
2012-02-23 (first published: 2010-10-13)
11,955 reads
2012-02-21 (first published: 2010-10-06)
9,424 reads
2012-02-16 (first published: 2010-09-29)
8,647 reads
2012-02-09 (first published: 2010-09-15)
10,181 reads
2012-02-07 (first published: 2010-09-08)
9,745 reads
2012-02-02 (first published: 2010-09-01)
9,298 reads
2012-01-31 (first published: 2010-08-11)
9,240 reads
2012-01-26 (first published: 2010-08-04)
9,111 reads
Blogs
Better Trigger Design: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
SQL Server in the Cloud – Are DBAs Still Needed?
By Kevin3NF
Things your cloud vendor may not tell you Here’s a common theme I...
AZ-900: Microsoft Azure Fundamentals – The Ultimate Beginner’s Guide to Cloud Mastery
By Rohit Garg
In an era where cloud computing drives innovation, understanding its fundamentals is no longer...
Forums
SQL - Conditional merge join
I want to add a condition in the joining columns part of the merge...
Is there a way to implement ROWS between logic?
Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...
Tracking changing prices and recalculating inventory value
I'm trying to figure out a how to do average costing over time in...
Question of the Day
What is Between?
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers