Click here to Skip to main content
   

Database

 
GeneralRe: SQL query Date Sort Problem PinmemberEddy Vluggen4-Dec-12 5:44 
AnswerRe: SQL query Date Sort Problem PinmemberMichael Potter4-Dec-12 9:11 
AnswerRe: SQL query Date Sort Problem Pinmemberjschell4-Dec-12 9:23 
Questionoltp vs olap Pinmembera.fatemeh2-Dec-12 11:51 
AnswerRe: oltp vs olap PinmemberMycroft Holmes2-Dec-12 12:49 
GeneralRe: oltp vs olap Pinmembera.fatemeh2-Dec-12 12:57 
GeneralRe: oltp vs olap PinmemberMycroft Holmes2-Dec-12 14:28 
GeneralRe: oltp vs olap Pinmembera.fatemeh2-Dec-12 14:41 
GeneralSQL instance name when using network group PinmemberAamir Saleem2-Dec-12 11:32 
GeneralRe: SQL instance name when using network group PinmemberMycroft Holmes2-Dec-12 12:43 
QuestionACL vs SQL for fuzzy matching PinmemberBen Dessau29-Nov-12 5:15 
AnswerRe: ACL vs SQL for fuzzy matching PinprotectorPete O'Hanlon29-Nov-12 6:07 
GeneralRe: ACL vs SQL for fuzzy matching PinmemberBen Dessau29-Nov-12 7:43 
GeneralRe: ACL vs SQL for fuzzy matching PinprotectorPete O'Hanlon29-Nov-12 7:50 
At the most basic, you're talking about Soundex matching, which isn't great. You might want to consider Full Text Indexing, which will return misspelled items if they are close enough. Of course, you can always implement your own fuzzy logic inside SQL Server, using CLR functions.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

QuestionSQL Query Pinmemberberba29-Nov-12 3:22 
AnswerRe: SQL Query PinmemberRichard Deeming29-Nov-12 3:50 
GeneralRe: SQL Query Pinmemberberba2-Dec-12 19:30 
QuestionSQL Server windows authentication Pinmemberzead29-Nov-12 0:49 
AnswerRe: SQL Server windows authentication PinmemberGarth J Lancaster29-Nov-12 0:59 
AnswerRe: SQL Server windows authentication Pinmemberjschell29-Nov-12 9:09 
GeneralRe: SQL Server windows authentication PinmemberChris Meech30-Nov-12 4:45 
QuestionNeed help with a tricky MS SQL Query Pinmembermuya mwansa27-Nov-12 7:46 
AnswerRe: Need help with a tricky MS SQL Query PinmemberEddy Vluggen27-Nov-12 14:31 
GeneralRe: Need help with a tricky MS SQL Query Pinmemberjschell28-Nov-12 9:43 
AnswerRe: Need help with a tricky MS SQL Query PinmemberDeepak Kumar1128-Nov-12 2:03 
QuestionBest Approach For Designing Database PinmemberAmbiguousName27-Nov-12 4:59 
AnswerRe: Best Approach For Designing Database Pinmemberjschell27-Nov-12 14:13 
AnswerRe: Best Approach For Designing Database PinmemberMycroft Holmes27-Nov-12 14:14 
AnswerRe: Best Approach For Designing Database PinmemberEddy Vluggen27-Nov-12 14:23 
AnswerRe: Best Approach For Designing Database PinmemberKrishna Kumar Soni3-Dec-12 2:04 
QuestionEXEC sp_helptext Pinmemberjojoba201126-Nov-12 23:43 
AnswerRe: EXEC sp_helptext PinmemberMycroft Holmes27-Nov-12 0:30 
QuestionRe: EXEC sp_helptext Pinmemberjojoba201127-Nov-12 0:38 
AnswerRe: EXEC sp_helptext Pinmemberdjj5527-Nov-12 1:59 
QuestionRe: EXEC sp_helptext [modified] Pinmemberjojoba201127-Nov-12 4:09 
AnswerRe: EXEC sp_helptext PinmemberEddy Vluggen27-Nov-12 14:33 
QuestionRECORD VALIDATION IN ACCESS Pinmemberteto26-Nov-12 6:19 
SuggestionRe: RECORD VALIDATION IN ACCESS PinmemberAndré Kraak26-Nov-12 6:56 
AnswerRe: RECORD VALIDATION IN ACCESS Pinmemberdjj5526-Nov-12 7:05 
Questionhow to compare an operation in where expression In sql [modified] PinmemberGREG_DORIANcod26-Nov-12 5:29 
AnswerRe: how to compare an operation in where expression In sql Pinmembers_magus26-Nov-12 6:20 
AnswerRe: how to compare an operation in where expression In sql PinmemberMycroft Holmes26-Nov-12 12:56 
Questiongrant permission on table in another database PinmemberDan_K26-Nov-12 4:55 
QuestionRe: grant permission on table in another database PinmemberChris Meech26-Nov-12 9:25 
QuestionHow to mearge local database with server database PinmemberJitendra Parida198723-Nov-12 23:00 
AnswerRe: How to mearge local database with server database PinmemberMycroft Holmes23-Nov-12 23:17 
AnswerRe: How to mearge local database with server database Pinmemberdjj5525-Nov-12 3:48 
GeneralRe: How to mearge local database with server database PinmemberJitendra Parida198725-Nov-12 19:13 
GeneralRe: How to mearge local database with server database PinmemberGREG_DORIANcod26-Nov-12 6:56 
AnswerRe: How to mearge local database with server database PinmemberDeepak Kumar1128-Nov-12 2:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web03 | 2.8.150123.1 | Last Updated 27 Jan 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid