Post reply

Query with column name as parameter

  • 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

  • September 3, 2010 at 4:12 am

    #1216081

    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)

  • September 3, 2010 at 7:59 am

    #1216177

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

  • September 3, 2010 at 10:00 am

    #1216264

    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)

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

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