Phil Factor (real name withheld to protect the guilty), aka Database Mole, has 30 years of experience with database-intensive applications.
Despite having once been shouted at by a furious Bill Gates at an exhibition in the early 1980s, he has remained resolutely anonymous throughout his career.
He is a regular contributor to Simple Talk and SQLServerCentral.
IsNumeric()
function, because it can often lead to data type conversion errors, when importing data. On SQL Server 2012 or later, use the Try_Convert()
or Try_Cast()
function instead. On earlier SQL Server versions, the only way to avoid it is by using LIKE
expressions. Read more