Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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 = 'DatasetVersion'
 +
 +
 +
 +===== Version Information =====
 +  * Entered :5/20/2015 David Kingsbury, thanks to Paul Monaghan for the Query
 +  * Version : Will work on all versions of SQL
 +
 +
 +