Posted by Tony Rogerson on 10/28/07 08:18

Or.... Practical SQL Solutions in the Real World.

--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]


"Greg D. Moore (Strider)" <mooregr_deleteth1s@greenms.com> wrote in message
news:13hubgltianpsb8@corp.supernews.com...
> <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
>
>

[Back to original message]