Timeline for Create a function to generate a column value in a specific format
Current License: CC BY-SA 3.0
18 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 15, 2020 at 9:05 | history | edited | CommunityBot |
Commonmark migration
|
|
| Jun 7, 2016 at 20:42 | comment | added | Molenpad | Generating key in the app code, then inserting into the database, with key going into indexed column would be something interesting to explore... | |
| Jun 7, 2016 at 18:58 | comment | added | Barcollin | Well I will keep working it Mayb I will findd something as...but how good/bad it can be if I generate these userkeys in the app code and then insert into a database | |
| Jun 6, 2016 at 21:10 | history | edited | Molenpad | CC BY-SA 3.0 |
added 182 characters in body
|
| Jun 6, 2016 at 19:55 | comment | added | Barcollin | I noticed that after reading more non-deterministic functions, so but is there no other way I can use to generate these userkeys? | |
| Jun 6, 2016 at 19:42 | comment | added | Molenpad | Yes, unfortunately that would be because it's using the field Created which is using the getdate() function. | |
| Jun 6, 2016 at 9:42 | comment | added | Barcollin | Thanks I have checked it out, and when I add persisted its says userkey cannot be persisted because the column is non-deterministic | |
| Jun 6, 2016 at 8:55 | history | edited | Molenpad | CC BY-SA 3.0 |
OP asked about indexing and primary keys
|
| Jun 6, 2016 at 8:09 | comment | added | Barcollin | Thanks I just saw that, and hiw would I use the userkey as primary key? | |
| Jun 2, 2016 at 11:41 | comment | added | Barcollin | I code works welk except that everyday it updates the userkeys on database. I dnt understand how but as date chancges it updates userkey. Please help me to fix this. | |
| Jun 2, 2016 at 1:44 | history | edited | Paul White♦ | CC BY-SA 3.0 |
Suggested improvement to use a separate Created column to prevent the ID changing every day
|
| Jun 1, 2016 at 22:16 | history | edited | Paul White♦ | CC BY-SA 3.0 |
Incorporated comment
|
| May 31, 2016 at 13:40 | vote | accept | Barcollin | ||
| May 31, 2016 at 13:39 | vote | accept | Barcollin | ||
| May 31, 2016 at 13:40 | |||||
| May 31, 2016 at 10:09 | history | edited | Molenpad | CC BY-SA 3.0 |
added 2 characters in body
|
| May 31, 2016 at 10:04 | history | edited | Molenpad | CC BY-SA 3.0 |
added 17 characters in body
|
| May 31, 2016 at 9:36 | history | edited | Molenpad | CC BY-SA 3.0 |
added 188 characters in body
|
| May 31, 2016 at 9:20 | history | answered | Molenpad | CC BY-SA 3.0 |