For a wholly numeric one, the kind is 1; for other ones, it's kind 2. When retrieving data that you want to sort, order by the kind of serial, then the serial - e.g. SELECT * FROM tblFoo ORDER BY ...

DECIMAL and NUMERIC data types in SQL are nearly same. What differentiates the two is the precision and scale. Precision is higher in NUMERIC, while it is smaller in DECIMAL data type.

Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...

So I've got this temp table in a stored procedure.Here's some code:Set @i = 1While @i ...

To test for ISNUMERIC effectively, I needed to write a SQL Server CLR function and deploy the assembly into SQL Server itself. After confirming with the SQL Server DBA that a CLR function would be ...