2017-10-31
1,070 reads
2017-10-31
1,070 reads
2017-10-03
1,047 reads
2017-04-04
1,173 reads
2013-04-11
1,857 reads
This Script will return the respective financial month(Starts from April to March) for a calander month Input(Starts from January to April), May use for many Consolidated Financial Reports.
2011-02-16 (first published: 2011-02-05)
1,508 reads
2009-11-30
3,399 reads
In the first of a series of articles on the tricks of tackling temporal data in SQL, Joe Celko discusses SQL's temporal data types and agonizes over the fact that, although there are ANSI/ISO Standards for temporal operations in SQL, every vendor has something different.
2008-12-31
1,141 reads
I need to write a function to determine if particular year is a leap year (i.e. February contains 29 days rather than 28 days). I know that there are various rules for calculating leap years. Is there an easy way to figure this out? Can you provide an example or two to validate various years?
2008-07-14
5,755 reads
This article is going to cover the newly introduced data types in SQL Server 2008 July CTP, and will specifically discuss the DATETIME functions.
2008-02-18
4,431 reads
Finding missing data in a sequence of numbers or dates is a common request of DBAs. Regular author Jacob Sebastian brings us a new article that shows just how you can do this.
2008-02-06
8,173 reads
I love this error. Primarily because it demonstrates two very important things. Errors matter....
I’m excited to announce that I will be offering a full-day pre-con about Power...
Comments posted to this topic are about the item From Source Control to Database...
Comments posted to this topic are about the item The Schema Name
Comments posted to this topic are about the item The Login Types, which is...