Click here to Skip to main content
15,877,280 members
Home / Discussions / Database
   

Database

 
QuestionHow do I write the insert sql statement for the following scenario ? Pin
karengsh3-Jun-17 22:30
karengsh3-Jun-17 22:30 
AnswerRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes4-Jun-17 13:49
professionalMycroft Holmes4-Jun-17 13:49 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh4-Jun-17 20:41
karengsh4-Jun-17 20:41 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes4-Jun-17 20:58
professionalMycroft Holmes4-Jun-17 20:58 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh4-Jun-17 22:12
karengsh4-Jun-17 22:12 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes5-Jun-17 12:05
professionalMycroft Holmes5-Jun-17 12:05 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh10-Jun-17 19:12
karengsh10-Jun-17 19:12 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes10-Jun-17 20:45
professionalMycroft Holmes10-Jun-17 20:45 
karengsh wrote:
Is it possible to use tutorNRIC as my primary key
Yes it is possible just wrong. A user should NEVER be able to edit a primary key.
karengsh wrote:
my tutorID is just an index for me to keep track how many people have signed up.
That statement means you need to do some reading/learning on database design. A primary key should be stupid and used for just one purpose, to identify the record, NOTHING else.

Normally you would create the primary records and when you link them (via the UI) you create the link record with the 2 primary keys.
Never underestimate the power of human stupidity
RAH

GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh11-Jun-17 17:38
karengsh11-Jun-17 17:38 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes11-Jun-17 23:39
professionalMycroft Holmes11-Jun-17 23:39 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh14-Jun-17 18:55
karengsh14-Jun-17 18:55 
Questionwhy we use datareader Pin
Mazahir Habib1-Jun-17 20:10
Mazahir Habib1-Jun-17 20:10 
AnswerRe: why we use datareader Pin
John C Rayan1-Jun-17 22:16
professionalJohn C Rayan1-Jun-17 22:16 
GeneralRe: why we use datareader Pin
Mycroft Holmes1-Jun-17 22:25
professionalMycroft Holmes1-Jun-17 22:25 
Questionattempt to load oracle client libraries threw badimageformatexception ssis Pin
indian1431-Jun-17 13:59
indian1431-Jun-17 13:59 
AnswerRe: attempt to load oracle client libraries threw badimageformatexception ssis Pin
Richard Deeming2-Jun-17 1:18
mveRichard Deeming2-Jun-17 1:18 
QuestionLoading Data on Demand Pin
Richard Andrew x6431-May-17 11:02
professionalRichard Andrew x6431-May-17 11:02 
AnswerRe: Loading Data on Demand Pin
Richard Deeming31-May-17 11:44
mveRichard Deeming31-May-17 11:44 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 13:05
professionalRichard Andrew x6431-May-17 13:05 
AnswerRe: Loading Data on Demand Pin
Mycroft Holmes31-May-17 13:01
professionalMycroft Holmes31-May-17 13:01 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 13:07
professionalRichard Andrew x6431-May-17 13:07 
GeneralRe: Loading Data on Demand Pin
Mycroft Holmes31-May-17 13:21
professionalMycroft Holmes31-May-17 13:21 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 13:28
professionalRichard Andrew x6431-May-17 13:28 
AnswerRe: Loading Data on Demand Pin
Eddy Vluggen31-May-17 13:21
professionalEddy Vluggen31-May-17 13:21 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 13:36
professionalRichard Andrew x6431-May-17 13:36 

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.