2023-08-07 (first published: 2008-03-20)
3,013 reads
Site Owners
2008-07-31
3,052 reads
2008-07-02
5,325 reads
2008-06-30
4,703 reads
2008-06-24
4,215 reads
2008-06-19
2,984 reads
2008-06-18
4,356 reads
2008-06-17
3,529 reads
2008-06-12
3,524 reads
2008-06-11
3,516 reads
Blogs
DATEADD Truncates the Number Parameter: #SQLNewBlogger
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
Our SQL Server is Slow! What Do I Do First?
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
Using SQLFluff
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Update records based on several common columns
I have 4 tables (apologies for the formatting of the tables, I don't know...
Eliminate a function by writing out the code is now throwing an error
/* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016...
Question of the Day
A Strange Choice
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci See possible answers