Query text vs SP

[Astricks]

When should I go for query & when should I prefer SP? For example, we can wrap a simple select query inside an SP . Is it a better way? Any technical advanatages by using a particular method? I'm asking just for optimizing my app.

*

[Colin Angus Mackay]

General rule: Go for a query when you are doing something quick and dirty. Go for a stored procedure in all other circumstances.

---

Upcoming events: * Glasgow Geek Dinner (5th March) * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos

[tommyligo]

SPs are the best for your db an sql: 1) less traffic on your network 2) best performance on your db 3) encapsulation and security are easier to manage.