LessThanDot Site Logo

LessThanDot

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 "data types"

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…

Read More...

SQL Advent 2011 Day 17: varchar(max)

Today we are going to take a look at varchar(max). Instead of using the text and ntext data types, you should get into the habit of using varchar(max) and nvarchar(max)

Read More...

Be careful when passing around parameters, make sure they are the same size and type

Someone tried to figure out why his data was showing the next day when he passed in today’s date. If you are not careful to use the same data type and this includes scale and precision as well, you can get some strange results. In this post I will take…

Read More...