Content Overview Probably the most challenging conversion is the conversion of a date and/or time, which is supplied as text, into a value of type date, time, datetime or datetime2. SQL Server provides the following data types, among others, for storing a date and/or time: To convert a date supplied as text, the CONVERT and … Read more
Content Overview SQL Server provides the bit data type for storing yes/no information. Converting an input value into a value of type bit can be a small challenge. Ideally, yes/no information is stored in the source system in a data type that only allows a 0 or 1. In fact, yes/no information is sometimes stored … Read more
Content Overview SQL Server provides the following data types for storing floating point numbers: The data types float and real are not precise data types. They are suitable for storing particularly large or small values, but at the expense of accuracy. This means that a number equal to 0 can apparently be stored, but which … Read more
SQL Server provides the following data types for storing currency values: The data type money is essentially identical to the data type decimal(19, 4) and the data type smallmoney to the data type decimal(10, 4). There are internal differences in how SQL Server stores a decimal value and a money/smallmoney value. However, these differences are … Read more
There is a lot of good literature on the subject of data quality. As a rule, this topic is described more theoretically, with impressive examples and the importance is proven with theories. However, I have not yet found any concrete instructions on how exactly to implement the checking and handling of bad data in an … Read more
This article describes how to safely convert input values to bigint, int, smallint and tinyint data types. A seemingly simple task, one would think. For example, what happens if you want to convert a decimal number or an empty string to a value of type int. Is the converted value automatically rounded? Does function return … Read more
This article describes how to safely convert input values to bigint, int, smallint and tinyint data types. A seemingly simple task, you might think. For example, what happens if you want to convert a decimal number or an empty string to a value of type int. Is the converted value automatically rounded? Does function return … Read more