|
|
Posted by Greg D. Moore \(Strider\) on 10/24/07 11:37
<paulschultz54@gmail.com> wrote in message
news:1193191383.235885.139270@y27g2000pre.googlegroups.com...
> On Oct 19, 9:06 am, --CELKO-- <jcelko...@earthlink.net> wrote:
>> >> how can i pass Column name using parameter? <<
>>
>> You don't do this; it is bad programming. A well-designed module of
>> code returns a predictable result. What you have is what I call a
>> "Britney Spears, Squids and Automobiles" module, since it can return
>> anything of any data type!
>>
>> Get a book on basic Software Engineering and read about coupling and
>> cohesion before you do any more programming in any language.
>
> Maybe they weren't responsible for the database design, but are being
> asked query from it due to business requirements or maybe it's not a
> critical application and it's was easier to load a flat file into
> Access than to design a proper normalized database. Regardless, it's
> a legitimate question (as are your concerns about unpredictable
> results), but to assume that Raghu doesn't know basic Software
> Engineering is rude.
You know, Joe has written several books, SQL for Smarties comes to mind.
However, one book that I doubt he'll ever be asked to write is "Joe Celko's
Guide to Winning Friends and Influencing People."
:-)
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
Navigation:
[Reply to this message]
|