4924RE: [SQLQueriesNoCode] Magic Numbers for NULL and Identity Fields
- Aug 14 12:39 AM
I have encountered sequences in Oracle and the headaches they can cause (and am glad I mainly work in the SQL Server side of the business). If they are so wedded to Oracle practices, why are they moving off? I know this is not your call but they need a ‘talking to’ that square pegs do not fit in round holes. This may have been the way in Oracle but SQL Server is not Oracle. I do not think there is a good solution to this problem for you other than to ‘recreate’ the Sequence logic in Oracle and good luck with that one. I have a system that has to interface with Oracle (we sort of exchange data) and to manage an alpha/number column on my side I ended up with a nasty little trigger to create some sequences but I typically on my side have to deal with 10 or 20 thousand rows per 24 hour cycle so the performance isn’t an issue. Doesn’t SQL Server 2012 have a Sequence structure now? I have not used it (my older system is 2008R2) but this might be a solution or at least worth investigating.
- << Previous post in topic