SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Vinoth Kumar / Auto generation key field / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 18:17:03 GMT20RE: Auto generation key fieldhttp://www.sqlservercentral.com/Forums/Topic629392-1449-1.aspxhow data will be inserted into Complaint tableWed, 08 Apr 2009 04:21:48 GMTvijayakRE: Auto generation key fieldhttp://www.sqlservercentral.com/Forums/Topic629392-1449-1.aspxAlso, wouldn't there be a potential concurrency issue with this approach (i.e. select max)? Don't you need to wrap this in a lock and actually perform the insert to prevent collisions?Tue, 13 Jan 2009 10:23:33 GMTAdam GardnerRE: Auto generation key fieldhttp://www.sqlservercentral.com/Forums/Topic629392-1449-1.aspxWhat is the purpose of this syntax from the article?:[font="System"]isnull(complaint_ID,null)[/font]Tue, 13 Jan 2009 10:19:21 GMTAdam GardnerAuto generation key fieldhttp://www.sqlservercentral.com/Forums/Topic629392-1449-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/65435/">Auto generation key field</A>[/B]Sat, 03 Jan 2009 18:28:18 GMTvinoth-750003