[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


Other related posts: