2015-11-26 (first published: 2015-11-02)
8,199 reads
db name
Blogs
Sic Transit Gloria Community
When Covid took out the PASS organization, I had someone say to me, “Well,...
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...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Error when trying to enable cdc . Could not update the metadata
Server and db in SQL SERVER 2019. I have multiple tables that are enabled...
Parameter dataset doesn't show results in dropdown
My report has been working fine. Now, when I run the report, the Location...
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