Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Of @@identity and surrogate keys - HELP!
Message
 
 
To
09/12/1999 22:28:20
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00301334
Message ID:
00301511
Views:
48
>Yes... I know and respect your opinion... but disagree with it. All the arguments I have heard against them are either implentation issues or View Designer issues.
>

Right...view designer issues...lets think outside the Fox box here...<s> Also, it appears this person is using SPT, not the view designer...

>Your correct... in this case he was specifically speaking of @@IDENTITY which is a SQL Server animal... but, to say a DBA won't allow any other technique like this, or that it is not accpetable to use in a SQL Server environment is also not correct. I work WITH DBA's not for them.
<

In many orgs, DBA's are the gatekeeper to enterprise data. And yes, you need to abide by many of their rules. And, there is such a thing as best practices...

Identity fields work just fine... One needs to understand how tha animal works. One cannot stop at ones interpretation of how he/she *thinks* they work...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform