Some questions to start a new project.

• luis ruiz

  SSC Rookie

  Points: 28

  More actions

  November 18, 2005 at 11:05 am

  #102941

  Hi, This my fiirst post here.

  I will start a new project so I want to ask you what preffer about:

     1. What object name conventions do you like to use: (a.Camell b.Pascal etc.)

     2. What auditoring method do you like to add to your data base.

     3. What data paging method do you preffer.

     4. What datatype do you like to put to yours primery keys

     5.  Do you use univer data models?

  Thank you!

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738683

  More actions

  November 21, 2005 at 11:17 am

  #605021

  I can answer a few, but I'm not sure what some are:

  1. I've used this (http://www.sqlservercentral.com/columnists/sjones/codingstandardspart1.asp), but there is a standard for metadata: ISO-11179

  2. If you mean auditing, there are 3rd party tools as well as custom ways to do this, but it depends on your requirements.

  3. ? Not sure what you mean

  4. Depends on what the table is. The PK should be dependent on the data model.

  5. No