Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009
    Posts
    5

    Unanswered: get table anme with the combination of colomns name

    select [table_name] + '' + Id + '' + [colomn_name] from [table_name]


    is there any chance to get this type of combined data..

    can someone help me....

    thanks in advance

  2. #2
    Join Date
    Dec 2008
    Posts
    135
    is this u want
    select distinct table_name+'"'+cast(id as varchar(32))+'"'+'id'
    from tablename e
    ,information_Schema.columns i
    where i.table_name ='tablename'

    select 'tablename'+'"'+cast(id as varchar(32))+'"'+'id'
    from tablename

  3. #3
    Join Date
    Jul 2009
    Posts
    5
    yea this is what i want

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •