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.

None. This is a selection query and no data is modified in the running of it.

sp_dboption '', 'numeric roundabort', 'false'
  • Entered : 10/26/2010
  • Version :
You could leave a comment if you were logged in.