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. > 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187247 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
