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.
| Author |
Topic |
|
nic
Posting Yak Master
209 Posts |
 Posted - 2001-09-19 : 14:20:29
|
| Hi,I'm writing a web app that calls a number of stored procedures for any complicated or long sql statement, but I also have a number of vary basic statements (select * from table where keyname = keyvalue) that are currently stored in the web pages themselves. I was curious on people's ideas. Should I:A. leave them in the web pages since they are so simple.B. create a sp for each simple statement.C. create a "general" sp that I can pass in tablename, keyname, keyvalue etc. that will return the recordset.For consistency, it would be nice to have all the sql in one place, but I was curious on people's ideas.Thanks in advanceNic |
|
|
|
|
|
simple store procedures