Timeline for creating a multi table "identity" column (faux identity)
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 5, 2014 at 20:00 | history | edited | RubberChickenLeader | CC BY-SA 3.0 |
deleted 95 characters in body
|
| Nov 5, 2014 at 19:59 | vote | accept | RubberChickenLeader | ||
| Nov 5, 2014 at 19:34 | answer | added | spaghettidba | timeline score: 3 | |
| Nov 5, 2014 at 18:13 | comment | added | RubberChickenLeader | @ypercube, We are a large company with multiple servers. We have not picked which server this will go on so I dont know which version of SQL I will be using. Pushing for 2012 now though. | |
| Nov 5, 2014 at 18:01 | comment | added | ypercubeᵀᴹ |
Use SELECT @@version; to check your version.
|
|
| Nov 5, 2014 at 17:58 | history | edited | RubberChickenLeader | CC BY-SA 3.0 |
added 186 characters in body
|
| Nov 5, 2014 at 17:50 | comment | added | RubberChickenLeader | @Mike, The problem is that I will have 2 different processes with 2 different sets of tables so using an IDENTITY on one table and carrying it over wont work. All ready had thought about that. | |
| Nov 5, 2014 at 17:48 | comment | added | RubberChickenLeader | @spaghettidba Not sure on version but 2012 may be possible. After looking at SEQUENCE it will solve the problem exactly like I want to solve it. Thanks for the hint on that one. | |
| Nov 5, 2014 at 16:52 | comment | added | Mike |
If pre 2012, can you not have table Step1 have an IDENTITY column and after inserting, return the assigned IDENTITY value and use that in your Step2 and History INSERT statements?
|
|
| Nov 5, 2014 at 16:31 | comment | added | spaghettidba | Which SQL Server version? If you're on 2012, a SEQUENCE might do. | |
| Nov 5, 2014 at 16:19 | history | edited | RubberChickenLeader | CC BY-SA 3.0 |
Clearer title
|
| Nov 5, 2014 at 15:50 | history | asked | RubberChickenLeader | CC BY-SA 3.0 |