InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 03:45:01 GMT20http://www.sqlservercentral.com/Forums/Topic1265477-49-1.aspxWould still like to know who this "they" is.Look up identity columns in Books Online.Mon, 12 Mar 2012 13:52:53 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1265477-49-1.aspxThat's all they ask me to do. Event I'd is an attribute in table. Which will be primary key. And now needs to be auto generatedMon, 12 Mar 2012 13:50:42 GMTdilakshan31http://www.sqlservercentral.com/Forums/Topic1265477-49-1.aspxWithout clearer explanations, we're not likely to have a clue either. Have you asked the teacher/lecturer?Mon, 12 Mar 2012 13:40:03 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1265477-49-1.aspxIts part of my project I have. I have no clue on how to do thisMon, 12 Mar 2012 13:31:29 GMTdilakshan31http://www.sqlservercentral.com/Forums/Topic1265477-49-1.aspxCan you be more specific? What is the requirements for the EventID? What's it going to be used for? (if nothing, why do 'they' care about how it's generated)?Mon, 12 Mar 2012 13:25:12 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1265477-49-1.aspx[quote][b]dilakshan31 (3/12/2012)[/b][hr]Ok they have asked us to create a database which I have and now I need to create a table. They ask for event I'd to be unique and then ask for it to be auto generated[/quote]Who is this "they" you are talking about?Mon, 12 Mar 2012 13:23:54 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1265477-49-1.aspxOk they have asked us to create a database which I have and now I need to create a table. They ask for event I'd to be unique and then ask for it to be auto generatedMon, 12 Mar 2012 13:19:33 GMTdilakshan31http://www.sqlservercentral.com/Forums/Topic1265477-49-1.aspxNo such thing as SQL 2003.There are many ways to generate artificial primary keys (keys that have no meaning within the data), there's also the option not to use an artificial primary keys but rather choose one of the candidate keys from the data as the primary key. Can you be a little clearer what you're asking?Mon, 12 Mar 2012 13:11:24 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1265477-49-1.aspxOk guys, I'm a student, new to sql and really need help. How do u auto generate your primary key? I'm my case its 'event Id' note old sql. Think its 2003Mon, 12 Mar 2012 12:57:35 GMTdilakshan31