Store a value to the Database and not a table...
Posted on 2011-09-13
MS SQL 2008.
I am storing a current Version Id to my database, and it is just a single value. I was hoping to not have to create a table just to house one value. Is there an elegant solution for storing one single value to a special point in the system tables? Database Variables, sort of like session variables?
Ultimately, this has to do with an installation manager needing to know which version is currently installed.
If you have an answer, please provide how to set the value, and how to retrieve/update it, if it is not standard SQL.