Reputation
7,878
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 29 52
Impact
~876k people reached

2d
awarded  Notable Question
Oct
2
awarded  Famous Question
Sep
9
awarded  Yearling
Jul
6
awarded  Popular Question
Jun
26
awarded  Good Answer
Apr
28
awarded  Nice Answer
Apr
19
awarded  Popular Question
Mar
20
awarded  Inquisitive
Mar
20
awarded  Curious
Feb
12
awarded  Notable Question
Jan
25
awarded  Notable Question
Dec
18
awarded  Popular Question
Dec
17
awarded  Notable Question
Dec
9
awarded  Popular Question
Oct
29
awarded  Popular Question
Oct
2
comment Pros and Cons of holding all the business logic in stored procedures in web application
@Nick.McDermaid well of course. Like I said, it depends on what your doing. For a simple CRUD app like a blog site or something, I can't think of any reason you'd want stored procedures... My main argument is to rarely use stored procedures when a standard single-trip query would work just as well. My mindset is to only use stored procedures when it is such a rich query that it makes the application code more readable and understandable when it's put into a stored procedure, or when it's doing something data heavy, like generating reports and such.
Sep
22
comment Pros and Cons of holding all the business logic in stored procedures in web application
@Nick.McDermaid which ones? Yes, I'm a coder, not a DBA. So, I'm going to be a bit skewed, but I think all my points are valid.
Sep
9
awarded  Yearling
Aug
28
awarded  Notable Question
Jun
25
awarded  Notable Question