Explanation of SQL
This query will set the database option for Numeric_RoundAbort to false. This option is necessary for certain queries to function properly. For example, the how-to_write_sql_to_extract_an_xml_value_from_a_database_field requires this option to be set, this query will globally set the option, so that it is not necessary for be called each time the query is executed.
Risk of Data Corruption if Run Improperly
None. This is a selection query and no data is modified in the running of it.
SQL
sp_dboption '', 'numeric roundabort', 'false'
Version Information
- Entered : 10/26/2010
- Version :
You could leave a comment if you were logged in.