Explaining User-Defined Types in SQL Server?
Having recently stumbled on User-Defined Types (UDTs) in SQL Server. I thought I’d write a blog to explain what user-defined types are? Why you should you use them? This blog post delves into what UDTs are, why they are useful, and how to use them in SQL Server. What are User-Defined Types (UDTs)? In SQL […]
SQL Server Date Handling
Working with dates in sql is one of the most challenging parts of data manipulation. In this blog we aim to describe some of the complexities of date handling in SQL Server. Data Types Prior to Microsoft SQL Server 2008 the only data types available were datetime or the smalldatetime. With the launch of SQL […]
