SQL Server 2012: Time Marches On
Greg Larsen explores the new SQL Server 2012 date and time functions and shows you how to exploit these functions in new application code.
2013-02-13
3,844 reads
Greg Larsen explores the new SQL Server 2012 date and time functions and shows you how to exploit these functions in new application code.
2013-02-13
3,844 reads
2012-11-27
2,213 reads
A quick solution is a table function that will create a date range based on the parameters given. Then, you can just join to the results.
2012-11-02
4,979 reads
2012-01-30 (first published: 2011-12-23)
897 reads
2012-01-20 (first published: 2011-12-16)
1,040 reads
2011-06-22 (first published: 2011-06-14)
1,908 reads
Find the last day (or number of days in a month) in one statement without having to use IFs or BUTs.
2011-05-10 (first published: 2011-04-29)
2,435 reads
2011-04-27 (first published: 2011-04-21)
2,765 reads
2010-11-26 (first published: 2010-11-04)
597 reads
A Flexible Day Of Week Function where a criteria can be passed as an integer to a stored procedure.
2010-10-13 (first published: 2010-10-06)
1,419 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers