Professional Web Applications Themes

How to use a variable as column name? - Microsoft SQL / MS SQL Server

Hi, Would you please tell me how to declare a variable as a column name and use it the a return value stored procedure? Thanks hb...

  1. #1

    Default How to use a variable as column name?

    Hi,

    Would you please tell me how to declare a variable as
    a column name and use it the a return value stored procedure?

    Thanks

    hb


    hb Guest

  2. #2

    Default Re: How to use a variable as column name?

    you will have to make use of dynamic SQL. see following example on northwind
    database in which i am using tablename as a variable. Similarly you can use
    column name.
    Ex:
    Declare DynamicSql nvarchar(1024), TotalRecords int ,TableName
    varchar(256)
    select tablename='customers'
    select DynamicSql = 'Select TotalRecords = COUNT(*) FROM '+ TableName
    exec sp_executesql dynamicsql, N'TotalRecords int output', TotalRecords
    output
    print totalrecords

    --
    -Vishal

    "hb" <com> wrote in message
    news:e9z#phx.gbl... 


    Vishal Guest

  3. #3

    Default Re: How to use a variable as column name?

    hb wrote: 

    http://www.algonet.se/~sommar/dynamic_sql.html


    Bob Guest

Similar Threads

  1. Use array/variable data to populate column informationfor DataGrid
    By js_theywill in forum Macromedia Flash Data Integration
    Replies: 1
    Last Post: March 18th, 04:25 PM
  2. Variable DataGrid Column Text
    By Alan Z. Scharf in forum ASP.NET Data Grid Control
    Replies: 3
    Last Post: December 8th, 09:30 PM
  3. Column Header with Variable
    By Hai in forum ASP.NET Data Grid Control
    Replies: 2
    Last Post: October 12th, 10:15 PM
  4. Replies: 0
    Last Post: July 7th, 08:32 AM
  5. Replies: 0
    Last Post: January 8th, 02:59 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139