March 8, 2006 at 4:34 am
In SQL 2000, what are the basic rules to define column names in a table?
March 8, 2006 at 5:10 am
Hi - check identifiers - overview in BOL. Basically
1 to 128 chars. Start with a letter or underscore. I think you can start with # or @ but it gets confusing.
Some people allow spaces e.g. 'First Name' but you have to code it [First Name]. Some folk replace the space with an underscore, I find this hard work when reading out to someone. It also uses more characters than is needed. CamelCaping is my choice e.g. 'FirstName'
March 9, 2006 at 3:00 am
Thank You Allen.
Is there any other important points to be considered at the time of giving field names?
March 9, 2006 at 3:17 am
A good one I picked up was not to use plurals. E.G use Week not Weeks
March 9, 2006 at 10:29 am
After the system reequirements ( see BOL) everything else is convention. Never use single character column names unless you are into pain. Whatever you come up with keep it consistent. Either always use plural or never use plural, Always cap the first letter or never cap the first letter. Consistency is the key to readability.
Scott
March 10, 2006 at 11:01 pm
Thank You very much for all u'r replies.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply