Single store procedure perform all dml operation in sqlserver 2005

Question

0.00/5 (No votes)

See more:

I want to perform all dml operation by a single stored procedure in sql server 2005. how could I achieve this? Please Help

Posted 11-Aug-12 2:51am

_Raj sinha

Updated 11-Aug-12 2:55am

v2

Add a Solution

Comments

Mohamed Mitwalli 11-Aug-12 10:06am

Why you want to do this ??

Wendelius 11-Aug-12 10:14am

You should explain more. Why you want to do this, do you want all DML operations for one table or several tables and so on

[no name] 11-Aug-12 11:04am

Okay so do it. It's a bad idea but go ahead anyway. Plenty of examples of how to do this very thing if you search for it.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Answer 1 · 2012-08-11T19:20:00

The only way this is possible is through the use of EXEC, but code using EXEC will run with the users security permissions, so you will have to give access to tables and views etc.

Generally this is not a good practice, if you are looking to write less code and having less to maintain then I would suggest not using stored procedures and embedding SQL in your code (much faster, single source control point, and not bound to a specific vendor).

_Amy · Answer 2 · 2012-08-11T19:27:00

This will not be the good option. You'll find much difficulty to manage the data. If you want to use single stored procedure for all the DML operation you can have it but you need to maintain an indicator as input parameter. Every time you need to check the parameter and based upon that you need to perform the operations. Better to go with the individual parameters.

--Amit

Single store procedure perform all dml operation in sqlserver 2005

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0