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
466 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
466 reads
Shows how to return data with a "rownumber". Some unique column is needed.
2002-04-05
344 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
193 reads
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Dears, In my company, we have certain master data domains like customer; Vendor; Product;...
Hi All, Hi All, I want to convert columns result into rows with comma....
Does multi subnet failover with standard edition of sqlserver supports DB Mirror or AG...