Hi,
I am trying to Pass Column Name(FieldName) using Parameter in SQL
Statement... But i am getting error...
how can i pass Column name using parameter???
Example:
in table i have fieldname ECountry...
Select @FName='ECountry'
Select @FName from Table...
How it works???
Thanx in Advance,
Regards,
Raghu...
(raghutumma@gmail.com) writes:
> I am trying to Pass Column Name(FieldName) using Parameter in SQL
> Statement... But i am getting error...
>
> how can i pass Column name using parameter???
>
> Example:
>
> in table i have fieldname ECountry...
>
> Select @FName='ECountry'
> Select @FName from Table...
>
> How it works???
Why would you do it in the first place? Given a well-designed database,
the request does not make very much sense. But if you have a less well-
designed database, you need to do:
SELECT CASE @paramname
WHEN 'thatfield' THEN thatfield
WHEN 'thisfield' THEN thisfield
WHEN 'leftfield' THEN leftfield
END
FROM tbl
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx
>> 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.
On Oct 19, 9:06 am, --CELKO--
> >> 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.
news:1193191383.235885.139270@y27g2000pre.googlegroups.com.. .
> On Oct 19, 9:06 am, --CELKO--
>> >> 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
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)"
news:13hubgltianpsb8@corp.supernews.com...
>
> news:1193191383.235885.139270@y27g2000pre.googlegroups.com.. .
>> On Oct 19, 9:06 am, --CELKO--
>>> >> 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
>
>