LessThanDot Site Logo


A decade of helpful technical content

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.

Browsing "conversions"

SQL Server Data Type Conversion Poster is available for download

Microsoft has made available two pdf files with a nice chart of all the data type conversions. It is pretty much the chart that belongs to the topic CAST and CONVERT (Transact-SQL). Now you have a way of printing a nice looking chart so that you can alw…


SQL Advent 2012 Day 2: Data types storage differences

SQL Server has two data types to store character data, both of them come in fixed and variable length sizes. The char and varchar data type uses one byte of store to store one character, the nchar and nvarchar data type uses two bytes of store to store one character. The nchar and nvarchar data types are used to store unicode of data