SQL Views in SP, is it ok? 
Author Message
 SQL Views in SP, is it ok?
Am using a view in my stored procedure? Is it just okay to use SQL Views..
Are views expensive to execute even if I use in a Stored Procedure..


Sat, 28 Feb 2004 19:06:54 GMT
 SQL Views in SP, is it ok?

It is fine. In most cases, you'll get the same query plan whether you use a view or
write the queries directly against the tables.

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com

Quote:

> Am using a view in my stored procedure? Is it just okay to use SQL Views..
> Are views expensive to execute even if I use in a Stored Procedure..



Sat, 28 Feb 2004 19:20:19 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Ok for .sql but not with a view ?

2. Am I OK to Install MDAC?

3. Ok, am I doing this ass-backwards?

4. Ok, am I doing this ass-backward

5. Use a sp to Make a view with a sp inside

6. ODBC Excel OK, SQL link not ok...?

7. ODBC Excel OK, SQL link not ok...?

8. SQL to retrieve views, sp's and tables

9. Is this SP written OK?

10. after sql server sp 4, existing views timeout

11. What SP am I running?

12. What SP am I running?


 
Powered by phpBB® Forum Software