Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2002-01-11 : 12:32:32
|
| I am looking for pros and cons. In most of my tables I create a primary key, identity and let it auto increment. I use this as my relation between other tables a lot of the time. Is this a bad practice?Should I be calculating the next field and using that as the identity? Joiningtwo int fields to create the identity?What are some pitfalls and best practices?Thanks2nd.Anyone know of a good resource or how I should go about exporting data from a fox pro DB ver 2.5 and then importing into SQL 2K. I will use DTS but not sureif SQL has a FOX driver to directly connect.slow down to move faster... |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-01-11 : 12:40:23
|
This article will give you one perspective. The resulting forum thread is an interesting read too.[url]http://www.sqlteam.com/item.asp?ItemID=2599[/url]Maybe graz should change the name of the article from "Identity and Primary Keys - Part 1" to "Rob's Waterloo"  JustinEdited by - justinbigelow on 01/11/2002 12:40:52Edited by - justinbigelow on 01/11/2002 12:41:55 |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-11 : 12:43:16
|
| This Article should help you outhttp://www.sqlteam.com/item.asp?ItemID=2599I think it shouldnt be a problem for you to create a ODBC for Forpro. it comes with with the standard drivers.Oops! justin already provided the link. it pressed the reply button and got busy with some work for few mins.....Speed CountsHTH----------------------------Anything that Doesn't Kills you Makes you StrongerEdited by - Nazim on 01/11/2002 12:45:54 |
|
|
|
|
|
|
Identity field and relations