Click here to Skip to main content
       

Database

 
QuestionOn the Naming of Columns for Lookup tables. PinmemberBrady Kelly17-Dec-12 22:44 
AnswerRe: On the Naming of Columns for Lookup tables. PinmemberMycroft Holmes17-Dec-12 23:19 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberBrady Kelly17-Dec-12 23:26 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberMycroft Holmes18-Dec-12 1:11 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberBrady Kelly18-Dec-12 1:15 
AnswerRe: On the Naming of Columns for Lookup tables. PinmemberPIEBALDconsult18-Dec-12 4:05 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberBrady Kelly18-Dec-12 4:12 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberPIEBALDconsult18-Dec-12 4:46 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberBrady Kelly18-Dec-12 5:34 
QuestionOn Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly14-Dec-12 3:02 
JokeRe: On Strategies to Spell Check the Structure of a Database. PinmemberChris Meech14-Dec-12 4:31 
AnswerRe: On Strategies to Spell Check the Structure of a Database. PinmemberSimon_Whale14-Dec-12 4:52 
AnswerRe: On Strategies to Spell Check the Structure of a Database. PinmemberMycroft Holmes14-Dec-12 13:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly14-Dec-12 16:36 
I'm going to do all columns. My naming conventions nearlly always use full names, e.g.
SecondaryEducation	ExamNumber
SecondaryEducation	HighestLevelId
SecondaryEducation	HighestLevelOther
SecondaryEducation	SchoolName
SecondaryEducation	EnglishProficiencyLevelId
SecondaryEducation	EnglishProficiencyInstitution
SecondaryEducationLevel	Id
SecondaryEducationLevel	Description
I'll be using a set of algorithms to split names in various ways, hopefully into separate English words, as my example above would do quite nicely. Then I'll have a configurable set of standard non- or semi-English tokens that can be checked for deviation from their definitions, and good old ignore lists.
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberMycroft Holmes14-Dec-12 16:57 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly14-Dec-12 17:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberMycroft Holmes14-Dec-12 21:13 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly14-Dec-12 21:25 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberPIEBALDconsult15-Dec-12 8:49 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly15-Dec-12 18:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberPIEBALDconsult18-Dec-12 10:47 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly18-Dec-12 11:01 
Questionsending images from a SQL database to a user's email as attachment PinmemberMember 946798213-Dec-12 2:16 
QuestionRe: sending images from a SQL database to a user's email as attachment PinmemberEddy Vluggen13-Dec-12 2:29 
QuestionODBC Returns Wrong Data PinmemberGenJerDan12-Dec-12 5:23 
AnswerRe: ODBC Returns Wrong Data PinmemberChris Meech12-Dec-12 5:50 
GeneralRe: ODBC Returns Wrong Data PinmemberGenJerDan12-Dec-12 6:20 
GeneralRe: ODBC Returns Wrong Data PinmemberChris Meech12-Dec-12 6:28 
AnswerRe: ODBC Returns Wrong Data PinmemberPIEBALDconsult12-Dec-12 6:28 
GeneralRe: ODBC Returns Wrong Data PinmemberGenJerDan12-Dec-12 7:18 
GeneralRe: ODBC Returns Wrong Data PinmemberPIEBALDconsult12-Dec-12 8:51 
GeneralRe: ODBC Returns Wrong Data PinmemberGenJerDan12-Dec-12 8:54 
AnswerRe: ODBC Returns Wrong Data Pinmemberjschell12-Dec-12 9:05 
GeneralRe: ODBC Returns Wrong Data PinmemberGenJerDan12-Dec-12 9:14 
GeneralRe: ODBC Returns Wrong Data Pinmemberjschell14-Dec-12 12:38 
GeneralRe: ODBC Returns Wrong Data PinmemberGenJerDan14-Dec-12 13:24 
AnswerRe: ODBC Returns Wrong Data PinmemberMycroft Holmes12-Dec-12 12:01 
GeneralRe: ODBC Returns Wrong Data PinmemberGenJerDan13-Dec-12 3:05 
QuestionRe: ODBC Returns Wrong Data PinmemberEddy Vluggen13-Dec-12 4:24 
QuestionUsing .Net and SMO on multiple SQL versions PinmemberEricCiz11-Dec-12 23:45 
AnswerRe: Using .Net and SMO on multiple SQL versions PinmemberEddy Vluggen12-Dec-12 3:10 
QuestionSelecting issue in SQl Server Pinmemberrakeshs31211-Dec-12 23:06 
AnswerRe: Selecting issue in SQl Server PinmemberEddy Vluggen12-Dec-12 3:07 
QuestionGenerating Code in Dept-001/Fin.Year Format PinmemberVinay Meka11-Dec-12 22:41 
QuestionRe: Generating Code in Dept-001/Fin.Year Format PinmemberEddy Vluggen12-Dec-12 3:06 
AnswerRe: Generating Code in Dept-001/Fin.Year Format PinmemberMycroft Holmes12-Dec-12 11:53 
QuestionHow to print an SSRS Report in PDF Format from my asp.net page PinmemberVinay Meka11-Dec-12 17:55 
AnswerRe: How to print an SSRS Report in PDF Format from my asp.net page - Crosspost PinmvpRichard MacCutchan11-Dec-12 21:30 
Questionreading individual files in a database backup set PinmemberDan_K10-Dec-12 22:44 
AnswerRe: reading individual files in a database backup set Pinmemberdjj5511-Dec-12 3:58 

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
Web04 | 2.8.140916.1 | Last Updated 18 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid