Click here to Skip to main content
14,697,729 members
Home » Discussions » Database
   

Database

 
GeneralRe: Dynamic Query Question Pin
PIEBALDconsult12-Aug-11 18:57
professionalPIEBALDconsult12-Aug-11 18:57 
GeneralRe: Dynamic Query Question Pin
S Douglas13-Aug-11 9:20
professionalS Douglas13-Aug-11 9:20 
GeneralRe: Dynamic Query Question Pin
PIEBALDconsult13-Aug-11 10:29
professionalPIEBALDconsult13-Aug-11 10:29 
GeneralRe: Dynamic Query Question Pin
S Douglas13-Aug-11 23:30
professionalS Douglas13-Aug-11 23:30 
GeneralRe: Dynamic Query Question Pin
PIEBALDconsult13-Aug-11 8:15
professionalPIEBALDconsult13-Aug-11 8:15 
QuestionUPDATE Multiple tables on one filed. [modified] Pin
Member 808202113-Jul-11 12:12
MemberMember 808202113-Jul-11 12:12 
AnswerRe: UPDATE Multiple tables on one filed. Pin
Blue_Boy14-Jul-11 0:29
MemberBlue_Boy14-Jul-11 0:29 
AnswerRe: UPDATE Multiple tables on one filed. Pin
Shameel14-Jul-11 1:09
professionalShameel14-Jul-11 1:09 
It is always a good idea to have foreign key relationships on tables. Creating indexes on the foreign keys will also speed up queries.

Why don't you try creating the foreign key relationships now with the ON UPDATE CASCADE option?
AnswerRe: UPDATE Multiple tables on one filed. Pin
smcnulty200014-Jul-11 23:39
Membersmcnulty200014-Jul-11 23:39 
AnswerRe: UPDATE Multiple tables on one filed. [modified] Pin
Niladri_Biswas18-Jul-11 3:12
MemberNiladri_Biswas18-Jul-11 3:12 
QuestionCalculate and display a progressive balance Pin
Rameez Raja11-Jul-11 21:48
MemberRameez Raja11-Jul-11 21:48 
AnswerRe: Calculate and display a progressive balance Pin
Corporal Agarn12-Jul-11 5:40
professionalCorporal Agarn12-Jul-11 5:40 
AnswerRe: Calculate and display a progressive balance Pin
smcnulty200014-Jul-11 23:34
Membersmcnulty200014-Jul-11 23:34 
GeneralRe: Calculate and display a progressive balance Pin
Rameez Raja16-Jul-11 23:49
MemberRameez Raja16-Jul-11 23:49 
GeneralRe: Calculate and display a progressive balance Pin
smcnulty200018-Jul-11 14:36
Membersmcnulty200018-Jul-11 14:36 
QuestionSelecting multiple columns from several tables without using JOIN Pin
Dominick Marciano11-Jul-11 5:41
professionalDominick Marciano11-Jul-11 5:41 
AnswerRe: Selecting multiple columns from several tables without using JOIN Pin
Blue_Boy11-Jul-11 5:55
MemberBlue_Boy11-Jul-11 5:55 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
David Mujica11-Jul-11 6:28
MemberDavid Mujica11-Jul-11 6:28 
AnswerRe: Selecting multiple columns from several tables without using JOIN Pin
kmoorevs11-Jul-11 11:08
Memberkmoorevs11-Jul-11 11:08 
AnswerRe: Selecting multiple columns from several tables without using JOIN Pin
Shameel11-Jul-11 22:30
professionalShameel11-Jul-11 22:30 
AnswerRe: Selecting multiple columns from several tables without using JOIN Pin
David Skelly12-Jul-11 4:54
MemberDavid Skelly12-Jul-11 4:54 
AnswerRe: Selecting multiple columns from several tables without using JOIN Pin
AnnieMacD14-Jul-11 7:24
MemberAnnieMacD14-Jul-11 7:24 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
Shameel14-Jul-11 19:52
professionalShameel14-Jul-11 19:52 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
smcnulty200014-Jul-11 23:46
Membersmcnulty200014-Jul-11 23:46 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
Shameel15-Jul-11 3:22
professionalShameel15-Jul-11 3:22 

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.