Tag Archives: SQL Server 2008

Recursive user defined function in SQL Server

Introduction In this post I will explain how write a recursive user defined function in SQL Server Description Recursive function is a function which calls itself for a certain number of times based on some business logic. We will create a simple recursive user defined function for calculating factorial of a number. Factorial of a… Read More »

How to store Date and Time in separate columns in SQL Server 2005

In this article I will explain how to store Date and Time in SQL Server 2005 using User Defined Type Introduction In SQL Server 2008 four new data types were added. Two of them are Date and Time for storing date and time as separate data types. But if you need to deal with separate… Read More »