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
440 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
440 reads
Shows how to return data with a "rownumber". Some unique column is needed.
2002-04-05
342 reads
How to get current day with the timeportion = 00:00:00.000.Works regardless of locale.
2002-04-05
433 reads
The fastest way of getting LastDayPreviousMonth / FirstDayCurrentMonth
2002-04-04
187 reads
By HamishWatson
This blog post relates to where you might be doing scale operations of your...
By HamishWatson
This blog post is about a situation where writing an IF THEN ELSE statement...
By Steve Jones
Data Saturday #2 – Guatemala is tomorrow. This is the first event on the...
Comments posted to this topic are about the item Data Privacy Grows in California
Hi I need to grant a user access to a DB on the server...
I have this table that unfortunately has spaces in the field, which I am...