Click here to Skip to main content
15,922,427 members
Home / Discussions / Database
   

Database

 
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 
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 
You are missing the point - NRIC is EDITABLE by the user therefore it should not be used as a primary key - you can put a unique constraint on it but do not use it as a foreign key in a related table.

karengsh wrote:
And I'd like tutorID as my index with incremental value
That is fine but it will not be a count of the records in the table.
Never underestimate the power of human stupidity
RAH

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 
GeneralRe: Loading Data on Demand Pin
Eddy Vluggen1-Jun-17 0:35
professionalEddy Vluggen1-Jun-17 0:35 
AnswerRe: Loading Data on Demand Pin
Jörgen Andersson31-May-17 22:18
professionalJörgen Andersson31-May-17 22:18 

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.