Professional Web Applications Themes

Dynamic SQL problem - Microsoft SQL / MS SQL Server

David, Thats normal.See the workaround mentioned in INF: Using Output Parameters with sp_executesql http://support.microsoft.com/?id=262499 -- Dinesh. SQL Server FAQ at http://www.tkdinesh.com "David" <xx.com> wrote in message news:021101c35154$eddcf750$gbl... ...

  1. #1

    Default Re: Dynamic SQL problem

    David,

    Thats normal.See the workaround mentioned in

    INF: Using Output Parameters with sp_executesql
    http://support.microsoft.com/?id=262499


    --
    Dinesh.
    SQL Server FAQ at
    http://www.tkdinesh.com

    "David" <xx.com> wrote in message
    news:021101c35154$eddcf750$gbl... 


    Dinesh.T.K Guest

  2. #2

    Default Re: Dynamic SQL problem

    EXEC lives in its own scope, so no, it is not defined.

    You might try something like:


    declare fiscalYear int

    EXEC sp_executesql
    N'SELECT fiscalYear = max(FiscalYear) from DateTable',
    N'fiscalYear INT output',
    fiscalYear output

    print fiscalYear



    And you might also read about the pitfalls of the approach you're taking:
    http://www.algonet.se/~sommar/dynamic_sql.html





    "David" <xx.com> wrote in message
    news:021101c35154$eddcf750$gbl... 


    Aaron Guest

  3. #3

    Default Re: Dynamic SQL problem

    use sp_executesql
    See following example:

    declare i int
    exec sp_executesql N'select i = 999', N'i int output', i output
    select i


    --
    -Vishal
    David <xx.com> wrote in message
    news:021101c35154$eddcf750$gbl... 


    Vishal Guest

Similar Threads

  1. Dynamic properties problem
    By shahinyan in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: May 15th, 12:06 PM
  2. Dynamic Query Problem
    By pnugent in forum Macromedia ColdFusion
    Replies: 1
    Last Post: June 15th, 10:46 PM
  3. problem with dynamic text :-(
    By georgemonse webforumsuser@macromedia.com in forum Macromedia Flash Sitedesign
    Replies: 3
    Last Post: October 8th, 12:21 AM
  4. Dynamic TextField Problem
    By Philipp Heltewig in forum Macromedia Flash
    Replies: 1
    Last Post: October 1st, 12:12 AM
  5. dynamic problem
    By LeeD in forum Macromedia Director Lingo
    Replies: 2
    Last Post: August 1st, 04:00 AM

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