Post reply

Views

  • July 10, 2003 at 1:08 pm

    #81948

    Are there arguments that cannot be used in a view, if so what are they?

  • July 11, 2003 at 1:39 pm

    #465174

    Well, I'll try to answer your question. Here are some things that you can't do with views (not necessarily arguments):

    - Can't use the ORDER BY clause (can use with TOP)

    - Can't use parameters to pass criteria

    - Can't use a View with temporary tables

    - Can't use INTO

    - Can't use COMPUTE or COMPUTE BY

    For reference, you should really check out this chapter on from Apress:

    http://www.sqlbook.com/836Ch08Fx.pdf

    All the best,

    Dale

    Edited by - dalec on 07/11/2003 1:41:39 PM

    Edited by - dalec on 07/11/2003 1:42:05 PM

    Edited by - dalec on 07/11/2003 1:42:53 PM


    All the best,

    Dale

    Author: An Introduction to SQL Server 2005 Management Studio

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply