In an interesting exercise in data conversion, Stephen Lasham brings us a nice article on basic manipulations.
Sql Server comes with a host of built in functions such as ISNULL, CONVERT and CAST. Now if that wasn't enough rope to hang ourselves with, as of Sql Server 2000 we gained the ability to create our own user defined functions. In this article I will be looking at the three main date functions DATEADD, DATEPART and DATEDIFF (there is a fourth called DATENAME but I want to get to the end of this article before you fall asleep so I decided to leave it for another date and time! And no it doesn't foretell the name of your future blind date so it's not as interesting as it sounds anyway) Then I will be combining all three in a user defined function of our own by which time our necks will be well and truly stretched
An IP address is something we all recognize and is a piece of data that is quite prevalent in many systems. However it is a piece of
data tha presents some challenges in its storage and retrieval. SQL Server guru David Poole presents us with a look at how you can
work with this strange formatting.
Learn how to build date generators without loops using SQL, and some useful techniques to help you manipulate date and time data.
Dealing with NULL data is something that often confuses new SQL Server developers, but even experienced DBAs might not understand all the intricacies of NULL operations. In a follow up to his highly acclaimed Four Rules of Null article, Michael Coles brings us a few new
tricks with NULLs.