Query with column name as parameter

Question

Post reply

Query with column name as parameter

Saravanan_tvr

SSCarpal Tunnel

Points: 4558
More actions
September 3, 2010 at 3:29 am

#226517

Hi ,
I have a functios that will return the column name like
column1,column2,column3,column4
but I want to execute the select query in View with that functions
Example:
select d.function_name() from table_name
instead of
select column1,column2,column3,column4 from table_name
thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

ColdCoffee SSC-Dedicated Points: 39971 More actions · Answer 1

you cant do it that way.. using dynamic query u can build it..

declare @sql varchar(max)

set @sql = ''

select @sql = 'SELECT ' + dbo.fn_columns() + ' FROM Table'

PRINT @sql

--EXEC (@sql)

Saravanan_tvr SSCarpal Tunnel Points: 4558 More actions · Answer 2

Hi In veiw the sq server wont allow to use the declarations,

Nevyn SSChampion Points: 14210 More actions · Answer 3

Saravanan_tvr (9/3/2010)
Hi In veiw the sq server wont allow to use the declarations,

Ok, so you've got a function that gives you a delimited list of columns.

And you want a view defined to dynamically use that list?

Why would you want to do this??? I think you're going to have to back up and explain to us what you're trying to accomplish and why because you can't do what you're trying to do, but there is almost certainly another way of accomplishing it (e.g. not using a function, not using a view, or using both but having the view contain all columns and using dynamic sql when selecting from the view)