Professional Web Applications Themes

Query yzer editor issues - Microsoft SQL / MS SQL Server

Hi, I have a stored procedure which compiles fine in Isql utility provided by Sql-Server 7.0 However if I compile the utility in Query yzer (sql- server 2000), I am getting the invalid column errors(few line's last characters and " characters). I did this by cut/paste from notepad as well as loading directly from file into Query yzer editor. Could you please provide me some clues on this. Thanks very much, Ravi...

  1. #1

    Default Query yzer editor issues

    Hi,

    I have a stored procedure which compiles fine in Isql
    utility provided by Sql-Server 7.0

    However if I compile the utility in Query yzer (sql-
    server 2000), I am getting the invalid column errors(few
    line's last characters and " characters).

    I did this by cut/paste from notepad as well as loading
    directly from file into Query yzer editor.

    Could you please provide me some clues on this.

    Thanks very much,
    Ravi
    Ravi Guest

  2. #2

    Default Re: Query yzer editor issues

    "Ravi" <com> wrote in message
    news:082301c34a0d$629d92b0$gbl... 

    Try adding this at the top of your stored proc:

    set quoted_identifier off


    Steve Guest

  3. #3

    Default Re: Query yzer editor issues


    Hello Friend,

    It worked, thanks for your help.

    Ravi.
     
    >
    >Try adding this at the top of your stored proc:
    >
    >set quoted_identifier off
    >
    >
    >.
    >[/ref]
    Ravi Guest

Similar Threads

  1. Replies: 1
    Last Post: May 31st, 08:56 PM
  2. Replies: 0
    Last Post: May 18th, 11:33 AM
  3. Replies: 9
    Last Post: October 24th, 02:25 PM
  4. Generate Table script from query yzer...
    By Andrew J. Kelly in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 10th, 12:08 AM
  5. Replies: 1
    Last Post: July 2nd, 09:09 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