Posted by BillCo on 05/01/07 09:18

On Apr 26, 2:47 pm, --CELKO-- <jcelko...@earthlink.net> wrote:
> WHERE base_column LIKE (@parameter, '%')
>
> The guy also needs to read anything on ISO-11179 naming conventions so
> he does nto use those silly prefixes, knows that there no such thing
> as "type_id", etc. But he did get plural and collective table names
> right.


Thanks for the ISO reference, I'll look into it - I'm coming from a MS
Access world where those _silly_ naming conventions actually make like
easier. You need to know in vba code at a glance whether it's a
table, query, lookup table - string, int, date - global, local,
modular... whatever - or you'll drive yourself crazy in the head
trying to debug the thing. I've been wondering about appropriate
naming conventions for SQL Server - but haven't as you can tell
bothered doing my research on the subject yet

Bill

• Next in forum: Re: Optional Where Parameters on Null Data
• Prev in forum: Re: Transform/transfer 50Gb - how to do it fast?
• Thread view: Re: Optional Where Parameters on Null Data

[Reply to this message]