Differences
This shows you the differences between two versions of the page.
control_sql_-_query_to_determine_oob_dataset_version [2019/01/27 11:29] |
control_sql_-_query_to_determine_oob_dataset_version [2019/01/27 11:29] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== | ||
+ | |||
+ | |||
+ | |||
+ | ===== Explanation of SQL ===== | ||
+ | |||
+ | |||
+ | |||
+ | This query will let you know which OOB Dataset is currently being used. | ||
+ | |||
+ | |||
+ | |||
+ | ===== Risk of Data Corruption if Run Improperly ===== | ||
+ | |||
+ | **None**. This is a selection query and no data is modified in the running of it. | ||
+ | |||
+ | |||
+ | |||
+ | ===== SQL ===== | ||
+ | |||
+ | |||
+ | |||
+ | SELECT Formula | ||
+ | |||
+ | |||
+ | |||
+ | FROM StoreConstant | ||
+ | |||
+ | |||
+ | |||
+ | WHERE itemtext = ' | ||
+ | |||
+ | |||
+ | |||
+ | ===== Version Information ===== | ||
+ | * Entered :5/20/2015 David Kingsbury, thanks to Paul Monaghan for the Query | ||
+ | * Version : Will work on all versions of SQL | ||
+ | |||
+ | |||
+ | |||