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
465 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
192 reads
Blogs
Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS
One of the nice things about the Microsoft Connector for Oracle is that it...
ChatGpt Experiments–Getting Documentation
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
A New Word: Jouska
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
Forums
partitioning a huge table
Hi folks I would like to get your views about partitioning a huge table...
SQL Website Development: A Comprehensive Guide to Building Dynamic Web Applicati
Introduction to SQL Website Development What is SQL? Importance of SQL in web development...
Ask SSC