what is surrogate key

Posted by Sreekanthv5 under Sql Server on 11/21/2011 | Points: 10 | Views : 25497 | Status : [Member] | Replies : 9
what is surrogate key and its usage?
when this key is used.




Responses

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
you can also refer following link
http://msdn.microsoft.com/en-us/library/aa905979%28v=sql.80%29.aspx

Rajesh Patel
Developer Trainer | Software Craftsman

Sreekanthv5, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 6/23/2012 [Member] Silver | Points: 25

Up
0
Down
http://www.sqlis.com/sqlis/post/Generating-Surrogate-Keys.aspx


Sreekanthv5, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 6/23/2012 [Member] Silver | Points: 25

Up
0
Down
Please see this also...
http://decipherinfosys.wordpress.com/2007/02/01/surrogate-keys-vs-natural-keys-for-primary-key/

Sreekanthv5, if this helps please login to Mark As Answer. | Alert Moderator

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

Up
0
Down
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

Login to post response