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
461 reads
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
461 reads
Shows how to return data with a "rownumber". Some unique column is needed.
2002-04-05
343 reads
How to get current day with the timeportion = 00:00:00.000.Works regardless of locale.
2002-04-05
434 reads
The fastest way of getting LastDayPreviousMonth / FirstDayCurrentMonth
2002-04-04
189 reads
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
backup log to int run every hour. If a log init backup is run...
Comments posted to this topic are about the item Speakers Are Normal People