T-SQL: Error converting data type varchar to numeric; Procedure workaround

check-data-type-of-a-field.sql

/* lsauer.com, 2013
 * DECIMAL fields, declared as NOT NULL, cannot be filled by a simple empty string ''
 * Insert '0.0' or '.0' instead
*/
CREATE PROCEDURE GetType(@TableName VARCHAR(100), @FieldName VARCHAR(100)) 
                 AS (SELECT system_type_id FROM sys.columns 
                       WHERE object_id = OBJECT_ID(@TableName, 'U') AND name = @FieldName)
GO
EXECUTE GetType N'MyTable', N'MyTableField'
/*For instance: 106 is DECIMAL*/

/*Delete when no longer needed*/
DROP PROCEDURE GetType GO