Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    27

    Unanswered: sp_columns into a variable

    Hello,
    I'm using sp_columns and would like to stock the result recordset into a variable (or simply get only the column name into a table variable in sql)

    Is there any way to select only the column name and put it into a table variable ?

    Thank

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Code:
    USE Northwind
    GO
    
    DECLARE @x TABLE(COLUMN_NAME sysname)
    
    INSERT INTO @x(COLUMN_NAME)
    SELECT COLUMN_NAME 
      FROM INFORMATION_SCHEMA.COLUMNS
     WHERE TABLE_NAME = 'Orders'
    
    SELECT * FROM @x
    GO
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2004
    Posts
    27
    Thank a lot

Posting Permissions

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