View or Stored Proceedure?

[John]

Hope you can give me some advise.

I am wanting to build a databse driven website. I am using Access to
connect to an SQL 2000 server to create tables etc.

I am using ASP/ASP.Net to build my site.

The question I have is on best method to retrive data. Lets say I have
a Table of Products, and one of those fileds is CurrentProduct and its
True or False. On my web page I want to retreive and list all products
that are marked as CurrentProduct True.

I could do this as part of the SQL statement in the web page ie
"Select * From Products Where CurrentProduct=True", I could create a
View that only shows Current Products and use Select * From
CurrentProductsView or I could create a stored prodceedure, that looks
very much like a view.

I know a bit about Access and Queries which is why I am using access
to manage Sql, but very liitle if anything about Stored Proceedures.
When should I use what? And what are the advantages / dis-advantages
of each approach?

Many thanks for any help you are able to provide.

[Simon Hayes]

"John" <jo************@hotmail.com> wrote in message
news:9a**************************@posting.google.c om...

Hope you can give me some advise.

I am wanting to build a databse driven website. I am using Access to
connect to an SQL 2000 server to create tables etc.

I am using ASP/ASP.Net to build my site.

The question I have is on best method to retrive data. Lets say I have
a Table of Products, and one of those fileds is CurrentProduct and its
True or False. On my web page I want to retreive and list all products
that are marked as CurrentProduct True.

I could do this as part of the SQL statement in the web page ie
"Select * From Products Where CurrentProduct=True", I could create a
View that only shows Current Products and use Select * From
CurrentProductsView or I could create a stored prodceedure, that looks
very much like a view.

I know a bit about Access and Queries which is why I am using access
to manage Sql, but very liitle if anything about Stored Proceedures.
When should I use what? And what are the advantages / dis-advantages
of each approach?

Many thanks for any help you are able to provide.

Stored procedures are usually the best way to retrieve data - see here for a
good explanation of why:

http://www.algonet.se/~sommar/dynamic_sql.html#Why_SP

Simon