Stored procedures or views? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Stored procedures or views?

Author

Topic

duanecwilson
Constraint Violating Yak Guru

273 Posts

Posted - 2009-08-12 : 13:55:17

I have some reports I have to create that don't take any parameters. Should I just create views for these or is it still better to use stored procedures?

Duane

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-08-12 : 14:32:11

I prefer stored procedures for all data access. You can reference views inside stored procedures plus you can do fancy logic in stored procedures whereas views you can only do select statements.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

duanecwilson
Constraint Violating Yak Guru

273 Posts

Posted - 2009-08-12 : 14:38:37

Thank you.

Duane

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources