balaji_rcs (12/24/2007)
Hi,Thanks for your reply. I want to remove the identity properties in the table totally. i.e I want to remove the identity while update also.
Yeah, uh-huh... what are you going to use to replace the auto-numbering property of the IDENTITY property? Sequence table? Better post that code so we can check it or you'll end up with a bazillion deadlocks per day. SELECT MAX()? Again, better post that code so we can make sure that you won't end up with dupe ID's on a high usage system.
And, then, you might as well convert all of your code to bloody cursors because you're gonna have a hell of a time inserting more than one row at a time no matter which of those two methods you use. If you have a third method not offered above, please post it... I want to see what type of knife you're falling on 😉
--Jeff Moden
Change is inevitable... Change for the better is not.