Transactions in function

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi Everyone,
Any kind of sql transaction can be done by function or not ??
if it is possible then how?? and
if no then why??

Posted 27-Jul-12 1:38am

krushna chandra jena

Add a Solution

Comments

OriginalGriff 27-Jul-12 7:44am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Use the "Improve question" widget to edit your question and provide better information.

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)

_Amy · Answer 1 · 2012-07-27T01:43:00

Hi,
For a function to be useful, it must produce a result. This is also said that the function returns a result or a value. When creating a function, you must specify the type of value that the function would return. To provide this information, after the name of the function, type the RETURNS keyword followed by a definition for a data type.

Refer the links:
http://www.functionx.com/sqlserver/functions/create.htm[^]
http://msdn.microsoft.com/en-us/library/ms174318.aspx[^]
http://stackoverflow.com/questions/5500618/is-it-possible-to-create-sql-server-function-using-transaction[^]

Santhosh Kumar Jayaraman · Answer 2 · 2012-07-27T01:47:00

Solution 2

No transactions are not allowed inside functions.

But if you want to do something like transaction then

SQL

begin transaction
exec usp_functionname
commit tran

Posted 27-Jul-12 1:47am

Santhosh Kumar Jayaraman

Updated 27-Jul-12 1:55am

v2