what is surrogate key

Posted by Sreekanthv5 under Sql Server on 11/21/2011 | Points: 10 | Views : 26861 | Status : [Member] | Replies : 7

what is surrogate key and its usage?
when this key is used.

Reply | Reply with Attachment

Posted by: Niladri.biswas on: 11/28/2011 [Member] Platinum | Points: 25

0	Refer this : http://en.wikipedia.org/wiki/Surrogate_key Best Regards, Niladri Biswas Sreekanthv5, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Arefin on: 11/29/2011 [Member] Starter | Points: 25

0	Hi, You can visit the below links: http://www.sqlservercentral.com/Forums/Topic564462-363-1.aspx#bm637090 http://www.geekinterview.com/question_details/17591 Thanks, Arefin Sreekanthv5, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Muhsinathk on: 6/21/2012 [Member] Bronze | Points: 25

0	Surrogate key is a unique identification key, it is like an artificial or alternative key to production key, bz the production key may be alphanumeric or composite key but the surrogate key is always single numeric key. Sreekanthv5, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Muhsinathk on: 6/21/2012 [Member] Bronze | Points: 25

0	Please refer these links http://en.wikipedia.org/wiki/Surrogate_key http://www.geekinterview.com/question_details/17591 Sreekanthv5, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ravianand on: 6/23/2012 [Member] Starter | Points: 25

0	Refer http://www.agiledata.org/essays/keys.html Regards, Ravi Sreekanthv5, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Rajkatie on: 6/23/2012 [Member] [MVP] Gold | Points: 25

0	you can also refer following link http://msdn.microsoft.com/en-us/library/aa905979%28v=sql.80%29.aspx Rajesh Patel R.P.A Developer \| Developer Trainer \| Clean Code Evangelist Sreekanthv5, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Perezellen on: 5/1/2015 [Member] Starter | Points: 25

0	A surrogate key in a database is a unique identifier for either an entity in the modeled world or an object in the database. Need more about admission essay writing. http://www.clazwork.com/admission-uk-essay-writing-service-connor Sreekanthv5, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts