You are here: Re: FK Assignment on Surrogate Key Table Throws Error « MsSQL Server « IT news, forums, messages
Re: FK Assignment on Surrogate Key Table Throws Error

Posted by --CELKO-- on 07/31/07 21:48

Have you considered a proper relational schema instead of a mock
sequential files? Do you even know about ISO-11179 data element
naming rules?

Look at what you posted. The name "UserPrecedence" is a relationship
among users, not an entity. You are using camelCase which is soooo
bad even MS gave up on it.

>> I am just learning my way around Foreign Key assignments involving surrogate keys. <<

Considering that FREIGN KEY is part of the foundation of RDBMS, isn't
that like a surgeon saying "I just found out about blood!" ? Also,
SQL Server has no surrogate keys -- read Dr. Codd. Why did you use
BIGINT? Do you really have a data model bigger than all the atomic
particles in the Universe?

Please give me an example of a "zip_code VARCHAR (50)" please? You
will get one because your design is so F***KED that it allows it. In
fqct this piece of sh*t is full of VARCHAR (50) columns. You never
looked at a single ISO standard, have you?

Please stop[p programing before you kill someone.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация