Click here to Skip to main content
15,940,271 members
Home / Discussions / Database
   

Database

 
GeneralRe: how to insert data in foreign key using jsp Pin
Faisal_Abdullah14-Mar-14 11:31
Faisal_Abdullah14-Mar-14 11:31 
GeneralRe: how to insert data in foreign key using jsp Pin
Faisal_Abdullah19-Mar-14 10:14
Faisal_Abdullah19-Mar-14 10:14 
GeneralRe: how to insert data in foreign key using jsp Pin
Mycroft Holmes19-Mar-14 14:13
professionalMycroft Holmes19-Mar-14 14:13 
SuggestionRe: how to insert data in foreign key using jsp Pin
Richard Deeming14-Mar-14 2:20
mveRichard Deeming14-Mar-14 2:20 
Questionto set foreign key or not to set? Pin
Jassim Rahma13-Mar-14 9:46
Jassim Rahma13-Mar-14 9:46 
AnswerRe: to set foreign key or not to set? Pin
_AK_13-Mar-14 10:16
_AK_13-Mar-14 10:16 
GeneralRe: to set foreign key or not to set? Pin
Jassim Rahma13-Mar-14 10:30
Jassim Rahma13-Mar-14 10:30 
AnswerRe: to set foreign key or not to set? Pin
_AK_13-Mar-14 10:49
_AK_13-Mar-14 10:49 
As I mentioned creating a foreign key constraint is required for refrential integrety and normally is a good practice. It do have an impact on performance which can be reduced by creating an index. If you craete the index on foreign key it will reduce the lookups.
.AK.

GeneralRe: to set foreign key or not to set? Pin
Jassim Rahma13-Mar-14 10:51
Jassim Rahma13-Mar-14 10:51 
AnswerRe: to set foreign key or not to set? Pin
_AK_13-Mar-14 11:07
_AK_13-Mar-14 11:07 
GeneralRe: to set foreign key or not to set? Pin
Jassim Rahma13-Mar-14 11:16
Jassim Rahma13-Mar-14 11:16 
GeneralRe: to set foreign key or not to set? Pin
_AK_13-Mar-14 11:21
_AK_13-Mar-14 11:21 
QuestionGroup by (first letter) Pin
nelsonpaixao12-Mar-14 16:42
nelsonpaixao12-Mar-14 16:42 
AnswerRe: Group by (first letter) Pin
Kornfeld Eliyahu Peter12-Mar-14 20:03
professionalKornfeld Eliyahu Peter12-Mar-14 20:03 
GeneralRe: Group by (first letter) Pin
nelsonpaixao16-Mar-14 9:50
nelsonpaixao16-Mar-14 9:50 
Questionsum of datediff to many dates Pin
ahmad_yossef11-Mar-14 4:08
ahmad_yossef11-Mar-14 4:08 
AnswerRe: sum of datediff to many dates Pin
Tim Carmichael11-Mar-14 5:40
Tim Carmichael11-Mar-14 5:40 
GeneralRe: sum of datediff to many dates Pin
ahmad_yossef11-Mar-14 23:05
ahmad_yossef11-Mar-14 23:05 
GeneralRe: sum of datediff to many dates Pin
Tim Carmichael12-Mar-14 10:57
Tim Carmichael12-Mar-14 10:57 
GeneralRe: sum of datediff to many dates Pin
ahmad_yossef12-Mar-14 23:19
ahmad_yossef12-Mar-14 23:19 
GeneralRe: sum of datediff to many dates Pin
Richard Deeming13-Mar-14 1:10
mveRichard Deeming13-Mar-14 1:10 
AnswerRe: sum of datediff to many dates Pin
Kornfeld Eliyahu Peter11-Mar-14 23:48
professionalKornfeld Eliyahu Peter11-Mar-14 23:48 
GeneralRe: sum of datediff to many dates Pin
ahmad_yossef12-Mar-14 2:23
ahmad_yossef12-Mar-14 2:23 
GeneralRe: sum of datediff to many dates Pin
Richard MacCutchan12-Mar-14 3:53
mveRichard MacCutchan12-Mar-14 3:53 
AnswerRe: sum of datediff to many dates Pin
jschell14-Mar-14 12:15
jschell14-Mar-14 12:15 

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.