Professional Web Applications Themes

query yzer - Microsoft SQL / MS SQL Server

This is because the way SQL Server works and Access is altogether different database. The way you execute it in SQL server is something like this: Ex: CREATE PROCEDURE proc1 (p1 smallint , p2 char(1) output) AS select p2 --Executing above procedure declare x char(1) select x=2 exec proc1 1, x output Look for the topic "EXECUTE" in Books online. -- -Vishal "Joel Gwynn" <com> wrote in message news:e#phx.gbl...  a  yzer, ...

  1. #1

    Default Re: query yzer

    This is because the way SQL Server works and Access is altogether different
    database.
    The way you execute it in SQL server is something like this:
    Ex:
    CREATE PROCEDURE proc1 (p1 smallint , p2 char(1) output)
    AS
    select p2
    --Executing above procedure
    declare x char(1)
    select x=2
    exec proc1 1, x output


    Look for the topic "EXECUTE" in Books online.

    --
    -Vishal

    "Joel Gwynn" <com> wrote in message
    news:e#phx.gbl... 

    yzer, 


    Vishal Guest

  2. #2

    Default Re: Query yzer

    No.

    Net

    Please reply only to the newsgroups.
    This posting is provided "AS IS" with no warranties, and confers no rights.
    You assume all risk for your use.
    Copyright SQLDev.Net 1991-2003 All rights reserved.

    "Rick C." <com> wrote in message
    news:microsoft.com... 


    Gert Guest

  3. #3

    Default Re: Query yzer

    But... here's a little workaround.
    Select "Query/Results in text" and run the query.
    Eliminate the offending line/lines from the result pane (you can edit
    anything else you want too).
    Leave the cursor in the results pane and select "File/Save".
    Voila!!! no more lines.

    "Gert E.R. Drapers" <SQLDev.Net> wrote in message
    news:phx.gbl... 
    rights. 
    >
    >[/ref]


    raydan Guest

  4. #4

    Default Re: Query yzer

    True.

    Net

    Please reply only to the newsgroups.
    This posting is provided "AS IS" with no warranties, and confers no rights.
    You assume all risk for your use.
    Copyright SQLDev.Net 1991-2003 All rights reserved.

    "raydan" <nospamcom> wrote in message
    news:%phx.gbl... 
    > rights. [/ref][/ref]
    of [/ref][/ref]
    the [/ref][/ref]
    this? 
    > >
    > >[/ref]
    >
    >[/ref]


    Gert Guest

Similar Threads

  1. write query in SQL Query yzer
    By John in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: August 5th, 08:55 PM
  2. Query yzer bug??
    By Andrew in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 21st, 11:44 PM
  3. 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