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
457 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
Daily Coping 27 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 26 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Seeding an Availability Group Replica from Snapshot
Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...
Forums
Need to provide access to database without giving access to production
Hoping I could find some best practice answers here: We have analysts who need...
Fill missing rows in dataset
I have data in table like this. I want to fill/insert the rows with...
Sign all stored procedures with a Certificate.
Hello, My company is going about ever increasing our security on all our Servers/databases....
Ask SSC