Click here to Skip to main content
15,846,038 members
Home / Discussions / Database
   

Database

 
GeneralRe: SSIS package Pin
Richard Deeming31-Oct-14 7:18
mveRichard Deeming31-Oct-14 7:18 
GeneralRe: SSIS package Pin
PIEBALDconsult31-Oct-14 7:33
mvePIEBALDconsult31-Oct-14 7:33 
QuestionLink to Microsoft Virtual System Pin
Shweta N Mishra31-Oct-14 4:41
professionalShweta N Mishra31-Oct-14 4:41 
AnswerRe: Link to Microsoft Virtual System Pin
Vijay Gill31-Oct-14 4:47
professionalVijay Gill31-Oct-14 4:47 
GeneralRe: Link to Microsoft Virtual System Pin
Shweta N Mishra31-Oct-14 6:21
professionalShweta N Mishra31-Oct-14 6:21 
QuestionUncertain on What to Use as Foreign Key of a Table Pin
ASPnoob30-Oct-14 6:19
ASPnoob30-Oct-14 6:19 
GeneralRe: Uncertain on What to Use as Foreign Key of a Table Pin
PIEBALDconsult30-Oct-14 6:59
mvePIEBALDconsult30-Oct-14 6:59 
AnswerRe: Uncertain on What to Use as Foreign Key of a Table Pin
Eddy Vluggen30-Oct-14 7:08
professionalEddy Vluggen30-Oct-14 7:08 
A foreign key is a primary key from another table. The "username" in the Users table (calling it userstable is redundant, all those things are tables and not chairs with little chance of confusing those) is not a foreign key - but it might be candidate-primary key.

Also, the artificial autonumber may be unique, but it does not mean that one can assign it blindly to be the primary key without asking oneself what the user will be using to uniquely identify a record.

You should look into normalization.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: Uncertain on What to Use as Foreign Key of a Table Pin
ASPnoob30-Oct-14 7:34
ASPnoob30-Oct-14 7:34 
Questionplsql Pin
Member 1118871528-Oct-14 22:28
Member 1118871528-Oct-14 22:28 
AnswerRe: plsql Pin
Mycroft Holmes28-Oct-14 23:03
professionalMycroft Holmes28-Oct-14 23:03 
GeneralRe: plsql Pin
PhilLenoir29-Oct-14 4:04
professionalPhilLenoir29-Oct-14 4:04 
RantRetrieve Data Using Comma Separated List Pin
ASPnoob28-Oct-14 21:10
ASPnoob28-Oct-14 21:10 
GeneralRe: Retrieve Data Using Comma Separated List Pin
Mycroft Holmes28-Oct-14 23:01
professionalMycroft Holmes28-Oct-14 23:01 
GeneralRe: Retrieve Data Using Comma Separated List Pin
Shweta N Mishra29-Oct-14 2:23
professionalShweta N Mishra29-Oct-14 2:23 
GeneralRe: Retrieve Data Using Comma Separated List Pin
Mycroft Holmes29-Oct-14 4:13
professionalMycroft Holmes29-Oct-14 4:13 
QuestionAdvice on Perfomance Turning of the Query Pin
Vimalsoft(Pty) Ltd28-Oct-14 8:27
professionalVimalsoft(Pty) Ltd28-Oct-14 8:27 
GeneralRe: Advice on Perfomance Turning of the Query Pin
PIEBALDconsult28-Oct-14 9:04
mvePIEBALDconsult28-Oct-14 9:04 
AnswerRe: Advice on Perfomance Turning of the Query Pin
Eddy Vluggen28-Oct-14 9:59
professionalEddy Vluggen28-Oct-14 9:59 
AnswerRe: Advice on Perfomance Turning of the Query Pin
Mycroft Holmes28-Oct-14 13:59
professionalMycroft Holmes28-Oct-14 13:59 
GeneralRe: Advice on Perfomance Turning of the Query Pin
Vimalsoft(Pty) Ltd4-Nov-14 22:56
professionalVimalsoft(Pty) Ltd4-Nov-14 22:56 
QuestionCombine results from 2 foxpro DBF files using union Pin
jkirkerx27-Oct-14 13:30
professionaljkirkerx27-Oct-14 13:30 
AnswerMakes no sense how it works Pin
jkirkerx27-Oct-14 14:01
professionaljkirkerx27-Oct-14 14:01 
QuestionSelect count on 2 DBF files Pin
jkirkerx27-Oct-14 12:11
professionaljkirkerx27-Oct-14 12:11 
GeneralRe: Select count on 2 DBF files Pin
PIEBALDconsult27-Oct-14 12:25
mvePIEBALDconsult27-Oct-14 12:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.