The Database Answers Community
For people interested in Databases
Best Practice
Information
This Group will provide a point of reference for guidance on the best way to solve specific problems. For example, how to design an Open-ended Database so that additional columns can be added to Tables without change to the design.
Website: http://www.databaseanswers.org/pi_best_practice_display/index.asp
Members: 9
Latest Activity: Dec. 29, 2009
Discussion Forum
How to Design an Open-Ended Database
Started by Barry Williams Jan. 4, 2008.
Comment Wall
Comment
-
Comment by Barry Williams on May 8, 2008 at 5:48pm -
Thanks to Tim for this advice on how to define a unique ID to be the Primary Key in a SQL Server Table.
"Unique id fields are not generated automatically.
A data type of unqiueidentifier doesn't get generated automatically when data is loaded..
A column with the data type set to uniqueidentifier is used to store GUID's. If you want something that's similar to an autonumber field in Access or a sequence in Oracle. then you should create a column of data type int and set the 'is identity' property to true.
HTH
Tim"
About
Badge
© 2010 Created by Barry Williams on Ning. Create a Ning Network!
You need to be a member of Best Practice to add comments!