nohandlesleft254
IS-IT--Management
Hi,
I am using a DB on sql server 2005 for an online account systerm. The sql db is a live copy of our internal systems DB (ODBC). My problem is that sometimes the internal system can send blank field values out to a numeric field in the SQL db, it fails to convert and stalls the system. I dont have much control over the internal system, so im looking for a way build in some sort of failsafe (eg if its blank, insert '0' or something) ...
thanks
I am using a DB on sql server 2005 for an online account systerm. The sql db is a live copy of our internal systems DB (ODBC). My problem is that sometimes the internal system can send blank field values out to a numeric field in the SQL db, it fails to convert and stalls the system. I dont have much control over the internal system, so im looking for a way build in some sort of failsafe (eg if its blank, insert '0' or something) ...
thanks