Stored Procedures Vs Views

[Tyler]

We have recently exported the tables from an Access data
base over to a SQL Server 2000 database. We have just
started to move the queries over as stored procedures. My
question is, when should Views be used instead of stored
procedures??

Regards Tyler

 

[Jeff Boyce]

Tyler

As I understand it, select queries get upsized to views, where action
queries get upsized to stored procedures.

If your query uses an ORDER BY clause, the view alone won't handle that, as
far as I know. And parameterized queries also end upsized to a stored
procedure.

That isn't to say that you couldn't use a View to return an updateable
recordset, because you can... you just need to pay attention to unique
indexes.

JOPO (just one person's opinion)