Dan Violet Sagmiller (He/Him)
asked on
Store a value to the Database and not a table...
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.