Click here to Skip to main content
15,395,361 members
Home / Discussions / Database
   

Database

 
QuestionDatabase design Questions? Pin
sepel13-Oct-08 23:23
Membersepel13-Oct-08 23:23 
AnswerRe: Database design Questions? Pin
bcozican14-Oct-08 2:09
Memberbcozican14-Oct-08 2:09 
GeneralRe: Database design Questions? Pin
Mark Churchill14-Oct-08 2:42
MemberMark Churchill14-Oct-08 2:42 
QuestionQuery Help Pin
Jaffer Mumtaz13-Oct-08 20:20
MemberJaffer Mumtaz13-Oct-08 20:20 
AnswerRe: Query Help Pin
bcozican14-Oct-08 2:18
Memberbcozican14-Oct-08 2:18 
GeneralRe: Query Help Pin
Jaffer Mumtaz14-Oct-08 18:41
MemberJaffer Mumtaz14-Oct-08 18:41 
QuestionMultiple columns in LIKE Pin
N a v a n e e t h13-Oct-08 15:58
MemberN a v a n e e t h13-Oct-08 15:58 
AnswerRe: Multiple columns in LIKE Pin
Mycroft Holmes13-Oct-08 17:42
professionalMycroft Holmes13-Oct-08 17:42 
I would not have thought of using the 2nd option.

The 3rd one is the most appropriate if only because the where clause will take advantage of any indexes where the concatenated string will not. This may be negated by using the like operator but I'm not sure.


Never underestimate the power of human stupidity
RAH

GeneralRe: Multiple columns in LIKE Pin
N a v a n e e t h13-Oct-08 19:23
MemberN a v a n e e t h13-Oct-08 19:23 
GeneralRe: Multiple columns in LIKE Pin
Andrew Rissing14-Oct-08 6:43
MemberAndrew Rissing14-Oct-08 6:43 
QuestionLoading column having $ sign to SQL Server... Pin
notes4we13-Oct-08 7:56
Membernotes4we13-Oct-08 7:56 
AnswerRe: Loading column having $ sign to SQL Server... Pin
Wendelius13-Oct-08 9:22
mveWendelius13-Oct-08 9:22 
QuestionArchiving a record Pin
Bolivarian13-Oct-08 7:07
MemberBolivarian13-Oct-08 7:07 
AnswerRe: Archiving a record Pin
Wendelius13-Oct-08 9:25
mveWendelius13-Oct-08 9:25 
GeneralRe: Archiving a record Pin
Bolivarian14-Oct-08 0:12
MemberBolivarian14-Oct-08 0:12 
GeneralRe: Archiving a record Pin
Wendelius14-Oct-08 4:54
mveWendelius14-Oct-08 4:54 
QuestionLEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
polishprogrammer13-Oct-08 7:05
Memberpolishprogrammer13-Oct-08 7:05 
AnswerRe: LEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
Wendelius13-Oct-08 7:36
mveWendelius13-Oct-08 7:36 
GeneralRe: LEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
polishprogrammer13-Oct-08 11:01
Memberpolishprogrammer13-Oct-08 11:01 
GeneralRe: LEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
Wendelius13-Oct-08 18:12
mveWendelius13-Oct-08 18:12 
GeneralRe: LEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
polishprogrammer14-Oct-08 3:38
Memberpolishprogrammer14-Oct-08 3:38 
GeneralRe: LEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
Wendelius14-Oct-08 5:02
mveWendelius14-Oct-08 5:02 
GeneralRe: LEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
polishprogrammer15-Oct-08 7:16
Memberpolishprogrammer15-Oct-08 7:16 
QuestionMS DTC has cancelled the transaction [modified] Pin
moon_stick13-Oct-08 5:10
Membermoon_stick13-Oct-08 5:10 
AnswerRe: MS DTC has cancelled the transaction Pin
Wendelius13-Oct-08 5:50
mveWendelius13-Oct-08 5:50 

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.