July 10, 2003 at 1:08 pm
Are there arguments that cannot be used in a view, if so what are they?
July 11, 2003 at 1:39 pm
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