[gameprogrammer] Re: Slightly offtopic: SQL Command
- From: Mikael Eriksson <mikael_miffe_eriksson@xxxxxxxx>
- To: gameprogrammer@xxxxxxxxxxxxx
- Date: Tue, 31 Oct 2006 03:56:49 +0100
On Tue, Oct 31, 2006 at 02:24:46PM +1300, Jake Briggs wrote:
> Which database? Serial is a sqlserver thing isn't it? You can't reliably
> do this sort of thing on sql server 2003 (I think that's the right
> version). My solution was convoluted and annoying, involving a dummy
> table to simulate a sequence (like a sequence from postgres) and making
> sure to keep the transaction atomic.
Could't you get the ids before and after the insert, and do somekind of
diff?
---------------------
To unsubscribe go to http://gameprogrammer.com/mailinglist.html
- Follow-Ups:
- [gameprogrammer] Re: Slightly offtopic: SQL Command
- From: Alan Wolfe
- References:
- [gameprogrammer] Gaming industry - how prevalent?
- From: Alan Wolfe
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Casey O'Donnell
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Alan Wolfe
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Agha Usman Ahmed
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Chris Nystrom
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Enrico Zschemisch
- [gameprogrammer] Slightly offtopic: SQL Command
- From: Kevin Jenkins
- [gameprogrammer] Re: Slightly offtopic: SQL Command
- From: Jake Briggs
Other related posts:
- » [gameprogrammer] Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- [gameprogrammer] Re: Slightly offtopic: SQL Command
- From: Alan Wolfe
- [gameprogrammer] Gaming industry - how prevalent?
- From: Alan Wolfe
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Casey O'Donnell
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Alan Wolfe
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Agha Usman Ahmed
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Chris Nystrom
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Enrico Zschemisch
- [gameprogrammer] Slightly offtopic: SQL Command
- From: Kevin Jenkins
- [gameprogrammer] Re: Slightly offtopic: SQL Command
- From: Jake Briggs