> S. Isaac Dealey wrote: >> I'm just saying that if the table being inserted into >> contains a
> no what you said was any session cross the server. that's > wrong. I was pretty sure I had corrected myself, but that's neither here nor there... >> Do you not consider Oracle a major db? Oracle has >> sequences which are >> not the same thing. The problem with identities using SQL >> Server is > oracle sequences are similar enough to include them. > probably "safer" > than identiy column in that you have to call them before > use, but it > still requires a bit of thought on the developers part > same as identity. >> that they're only useful / helpful during the insert -- >> they're a >> hideous, horrible, awful nightmare if you ever have to >> try and migrate > yes but that's not a very common occurance. idents work > well enough for > the most part. Heh... well my own personal experience is that if something is a nightmare, I will automatically need to use it frequently, no matter how infrequently anyone else uses it. :P s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187248 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
