Query with column name as parameter

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Query with column name as parameter

Query with column name as parameter

Rate Topic

Display Mode

Topic Options

Author

Message

Saravanan_tvr

Posted Friday, September 03, 2010 3:29 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, June 07, 2013 7:00 AM
Points: 269, Visits: 1,112

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

Many Thanks!
S.saravanan
“I am a slow walker, but I never walk backwards-
Abraham Lincoln”

Post #980093

ColdCoffee

Posted Friday, September 03, 2010 4:12 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:37 PM
Points: 2,248, Visits: 5,352

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)

Post #980109

Saravanan_tvr

Posted Friday, September 03, 2010 7:59 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, June 07, 2013 7:00 AM
Points: 269, Visits: 1,112

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

Many Thanks!
S.saravanan
“I am a slow walker, but I never walk backwards-
Abraham Lincoln”

Post #980218

Nevyn

Posted Friday, September 03, 2010 10:00 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 4:56 PM
Points: 281, Visits: 1,142

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)

Post #980325

« Prev Topic | Next Topic »

Permissions