Day of Week
To find the day of week, regardless of-SET DATEFIRST -SET DATEFORMAT -SET LANGUAGEThe first one is based on Zellers Congruence.The second one is a SQL server proprietary.
2002-04-05
449 reads
Simulate Rownumber (a la Oracle?)
Shows how to return data with a "rownumber". Some unique column is needed.
2002-04-05
343 reads
Today with no time portion
How to get current day with the timeportion = 00:00:00.000.Works regardless of locale.
2002-04-05
434 reads
LastDayPreviousMonth / FirstDayCurrentMonth
The fastest way of getting LastDayPreviousMonth / FirstDayCurrentMonth
2002-04-04
188 reads
Blogs
Using Framing for a Running Total–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Accessibility in your PowerPoint slide deck
This post is part of the series I kicked off here. You can read...
Daily Coping 28 Jul 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Conditional Update of Column
I can't remember ever trying this before, but I have need to do it...
Login failed: Password did not match that for the login provided.
I just installed a new instance of SQL Developer Edition - All my apps...
Ask SSC