Click here to Skip to main content
15,441,757 members
Home / Discussions / Database
   

Database

 
GeneralRe: Problem with the french character with sql server 2005 Pin
Luc Pattyn28-Dec-09 2:33
sitebuilderLuc Pattyn28-Dec-09 2:33 
GeneralRe: Problem with the french character with sql server 2005 Pin
Eddy Vluggen28-Dec-09 2:52
professionalEddy Vluggen28-Dec-09 2:52 
GeneralRe: Problem with the french character with sql server 2005 Pin
Luc Pattyn28-Dec-09 3:09
sitebuilderLuc Pattyn28-Dec-09 3:09 
GeneralRe: Problem with the french character with sql server 2005 Pin
Eddy Vluggen28-Dec-09 6:34
professionalEddy Vluggen28-Dec-09 6:34 
AnswerRe: Problem with the french character with sql server 2005 [modified] Pin
Eddy Vluggen28-Dec-09 2:19
professionalEddy Vluggen28-Dec-09 2:19 
QuestionHelp me understand this unusual query... [modified] Pin
Rafferty Uy27-Dec-09 15:44
MemberRafferty Uy27-Dec-09 15:44 
AnswerRe: Help me understand this unusual query... Pin
Luc Pattyn28-Dec-09 1:46
sitebuilderLuc Pattyn28-Dec-09 1:46 
QuestionRe: Help me understand this unusual query... Pin
Rafferty Uy28-Dec-09 15:36
MemberRafferty Uy28-Dec-09 15:36 
So the = operator does not check for exact string equality... I knew before that = is case insensitive but to think that it also trims the string!

Is LIKE the more preferable conditional operator then?
Is there a performance difference between = and LIKE?

Say for example WHERE tblField1 = 'something' vs. WHERE tblField1 LIKE 'something'

Rafferty

AnswerRe: Help me understand this unusual query... Pin
Luc Pattyn28-Dec-09 15:41
sitebuilderLuc Pattyn28-Dec-09 15:41 
QuestionRe: Help me understand this unusual query... Pin
Rafferty Uy28-Dec-09 15:46
MemberRafferty Uy28-Dec-09 15:46 
AnswerRe: Help me understand this unusual query... Pin
Luc Pattyn28-Dec-09 15:55
sitebuilderLuc Pattyn28-Dec-09 15:55 
GeneralRe: Help me understand this unusual query... Pin
Rafferty Uy28-Dec-09 16:00
MemberRafferty Uy28-Dec-09 16:00 
GeneralRe: Help me understand this unusual query... Pin
Luc Pattyn28-Dec-09 16:02
sitebuilderLuc Pattyn28-Dec-09 16:02 
AnswerRe: Help me understand this unusual query... Pin
WoutL28-Dec-09 21:24
MemberWoutL28-Dec-09 21:24 
GeneralRe: Help me understand this unusual query... Pin
Rafferty Uy29-Dec-09 15:34
MemberRafferty Uy29-Dec-09 15:34 
AnswerRe: Help me understand this unusual query... Pin
Member 450194029-Dec-09 5:47
MemberMember 450194029-Dec-09 5:47 
QuestionNeed help with constructing one query statement [modified] Pin
James Shao27-Dec-09 3:43
MemberJames Shao27-Dec-09 3:43 
AnswerRe: Need help with constructing one query statement Pin
Blue_Boy27-Dec-09 10:21
MemberBlue_Boy27-Dec-09 10:21 
GeneralRe: Need help with constructing one query statement Pin
James Shao27-Dec-09 18:38
MemberJames Shao27-Dec-09 18:38 
AnswerCan anyone please help? Pin
James Shao28-Dec-09 12:13
MemberJames Shao28-Dec-09 12:13 
QuestionProblem installing MS SQL 2008 Express Pin
AndyASPVB26-Dec-09 22:26
MemberAndyASPVB26-Dec-09 22:26 
AnswerRe: Problem installing MS SQL 2008 Express Pin
Roger Wright26-Dec-09 23:18
professionalRoger Wright26-Dec-09 23:18 
GeneralRe: Problem installing MS SQL 2008 Express Pin
AndyASPVB28-Dec-09 13:07
MemberAndyASPVB28-Dec-09 13:07 
GeneralRe: Problem installing MS SQL 2008 Express Pin
Roger Wright28-Dec-09 15:51
professionalRoger Wright28-Dec-09 15:51 
QuestionGIS Data Archive Pin
KORCARI25-Dec-09 22:44
MemberKORCARI25-Dec-09 22:44 

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.