Views

• brownguyr

  SSC Enthusiast

  Points: 107

  More actions

  July 10, 2003 at 1:08 pm

  #81948

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

• Dale Corey

  SSCrazy Eights

  Points: 9019

  More actions

  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