Professional Web Applications Themes

Views - Microsoft SQL / MS SQL Server

Are they any arguments that cannot be used inside a view, if there are what are they?...

Sponsored Links
  1. #1

    Default Views

    Are they any arguments that cannot be used inside a view,
    if there are what are they?
    Sponsored Links
    Guy Brown Guest

  2. #2

    Default Re: Views

    the following clauses cannot:

    ORDER BY (unless used with TOP)
    COMPUTE
    COMPUTE BY
    FOR XML

    Probably more but that is all I can think of at the moment.

    Why?

    Mike John

    "Guy Brown" <brownguy_rhotmail.com> wrote in message news:0b3301c34717$1da701d0$a001280aphx.gbl...
    > Are they any arguments that cannot be used inside a view,
    > if there are what are they?
    Mike John Guest

Similar Threads

  1. views in 8.0
    By Jason Tesser in forum PostgreSQL / PGSQL
    Replies: 1
    Last Post: January 11th, 01:26 PM
  2. 2 views
    By duff@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 4
    Last Post: May 28th, 06:03 PM
  3. Partitioned views
    By Amrit in forum IBM DB2
    Replies: 2
    Last Post: August 25th, 07:06 PM
  4. 360 degree views
    By Martin Euredjian in forum Photography
    Replies: 0
    Last Post: July 29th, 07:31 PM
  5. Replies: 4
    Last Post: July 8th, 07: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