The stored-procedures tag has no wiki summary.
51
votes
20answers
18k views
Stored Procedures a bad practice at one of worlds largest IT software consulting firms?
I'm working at a project in one of the world's top 3 IT consulting firms, and was told by a DBA that company best practice's state stored procedures are not a "best practice". This is so contrary to ...
17
votes
3answers
988 views
Do stored procedures violate three-tier separation?
Some colleagues have told me that having business logic in stored procedures in the database violates the three-tier separation, since the database belongs to the data layer whereas stored procedures ...
16
votes
7answers
3k views
How to suggest using an ORM instead of stored procedures?
I work at a company that only uses stored procedures for all data access, which makes it very annoying to keep our local databases in sync as every commit we have to run new procs. I have used some ...
16
votes
5answers
654 views
Do ORMs enable the creation of rich domain models?
After using Hibernate on most of my projects for about 8 years, I've landed on a company that discourages its use and wants applications to only interact with the DB through stored procedures.
After ...
9
votes
4answers
387 views
Stored procedure Naming conventions?
One of our senior developers has stated that we should be using a naming convention for stored procedures with an "objectVerb" style of naming such as ("MemberGetById") instead of a "verbObject" type ...
9
votes
2answers
353 views
How to TDD that the correct results are returned
I'm starting a new project, and trying very very hard to use TDD to drive the design. I've been pushing for years, and finally got approval to spend the extra time on this project to use it while I ...
8
votes
6answers
2k views
Pros and Cons of holding all the business logic in stored procedures in web application [duplicate]
In some organization I worked for web applications are developed basing all the business logic in Database stored procedures. For example, use html for view and servlet as controllers to divert the ...
7
votes
5answers
2k views
When not to use ORM and prefer stored procedures?
I am using PetaPoco micro-ORM. It is indeed very easy and secure to work with databases using ORM tools, but the only thing I hate is extra code. I used to put most of the code in the database itself ...
4
votes
2answers
594 views
Why put a simple query into a stored procedure in a web service?
I'm working as a junior programmer, and the senior programmer above me has instructed me to follow a certain unofficial policy for constructing new queries on our web development projects. Generally, ...
3
votes
5answers
162 views
What are the disadvantages of using stored procedures, SSIS, and SSRS to implement business applications?
Recently, it was suggested that many projects (where I work) should be implemented using some combination of stored procedures (on SQL Sever / T-SQL), SSIS, and SSRS.
In one specific project, SSIS ...
3
votes
1answer
310 views
Calling MSSQL stored procedure from Zend Controller ? Any other approaches?
MSSQL and DB, Zend as PHP Framework,
I am using this way to call SP with I/P Parameters and to get O/p Parameters.
It seems I am writing SQL code in PHP.
Any other good approaches?
$str1 = ...
2
votes
4answers
627 views
Using ASP.NET 4 and Stored Procedures
How popular are stored procedures today, compared to 5 years ago?
I ask this question because the book that I'm reading (an ASP.NET 4 book) has no stored procedures in it. Is it the ASP.NET 4 way ...
2
votes
2answers
331 views
Forced to write Stored Procedures
Can you think of some reasons that the management force the developers to write and call Stored Procedures instead of inline SQL statements directly?
Even a very simple CRUD statement, writing a ...
2
votes
1answer
183 views
Established coding standards for pl/pgsql code
I need to standardize coding practices for project that compromises, among others, of pl/pgsql database, that has some amount of nontrivial code.
I look for:
Code formatting guidelines, ...
2
votes
2answers
2k views
Java stored procedures in Oracle, a good idea?
I'm considering using a Java stored procedure as a very small shim to allow UDP communication from a PL/SQL package. Oracle does not provide a UTL_UDP to match its UTL_TCP. There is a 3rd party ...
2
votes
2answers
490 views
multi-language system and security with php
Firstly sorry for my English.
I'm coding new site. İt's like StackExchange, a social site and a blog. Whatever, I try to create multilanguage, however I can't decide how to do it.
I have to use ...
0
votes
1answer
221 views
Is it common to have stored procedures disabled on MySQL managed hosting plans?
I'm building an app that I think would benefit from the use of MySQL stored procedures. I know stored procedures have a bad reputation, but I think they suit my application well. Using stored ...
0
votes
0answers
37 views
T-SQL Issues With Defining 'AS' [migrated]
I am creating a fully dynamic application but have ran into a bit of a hiccup. There are multiple 'undefined' fields that can be defined by the users. The only problem is redisplaying them. Currently ...
-2
votes
3answers
380 views
Passing parameters to a stored procedure for use in a data reader object [closed]
using (SqlConnection con = db.con(user.Authority))
{
string command = "[Dashboard_GetUserPTOAndIncidentTotals] ";
using (SqlCommand cmd = new SqlCommand(command, con))
{
...
