Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.sqlserver.programming > #31346
| From | Michael Cole <invalid@invalid.com> |
|---|---|
| Newsgroups | microsoft.public.sqlserver.programming |
| Subject | Storage of "Do Not Show This Again" Flags |
| Date | 2019-02-05 12:49 +1100 |
| Organization | A noiseless patient Spider |
| Message-ID | <q3aq3m$qon$1@dont-email.me> (permalink) |
More of a generic theortical question rather than coding... For our application, we now want to introduce the concept of "Do Not Show This Again" tickboxes on popup dialogs. I need to store and retrieve these from the database. I am looking for suggestions on how they should be stored. The values will need to be stored against a user, for which we have a foreign key. I will provide stored procs for accessing these values - read and update. Options I had were: - 1. Single table, dual PK of Flag ID and User ID, with a single bit field to hold the value - non-existance will be considered as false. We could also have a string field to provide a description of what the flag is. Or perhaps better would be a linked table for the flag definition. 2. Single table, PKID of User ID, with a lot of bit fields for the values - I hold a manual spreadsheet of what column is what flag, and simply tell the developers which column to use when they request a new flag 3. Single table, PKID of User ID, with a bit-masked long integer for values - I hold a manual spreadsheet of what column is what bitmask, and simply tell the developers which number to pass when they request a new flag Obviously, the number of flags is uncertain, and will increment as the developers request new flags for new functionality, but the table itself does not need to be that clear in its operation, and it is purely a behind-the-scenes operation. Has anyone done this before, and what basic structure did you use? -- Michael Cole
Back to microsoft.public.sqlserver.programming | Previous | Next — Next in thread | Find similar
Storage of "Do Not Show This Again" Flags Michael Cole <invalid@invalid.com> - 2019-02-05 12:49 +1100 Re: Storage of "Do Not Show This Again" Flags Erland Sommarskog <esquel@sommarskog.se> - 2019-02-05 23:48 +0100
csiph-web