Transactions outside a Stored Procedure

Dave · Oct 14, 2006

Is it OK to use transactions outside a stored procedure? For example, as
part of a standard SQL statement using JDBC?

=?ISO-8859-1?Q?Arne_Vajh=F8j?= · Oct 14, 2006

Dave said:
Is it OK to use transactions outside a stored procedure? For example, as
part of a standard SQL statement using JDBC?

Of course it is OK. I even think it is relative common
to bundle multiple SQL statements in one transactions.

Arne

How can I find occurrences of a column name FPPaymentID in the entire database (e.g table, stored procedure etc) in SSMS?	2	Jun 20, 2023
Crud operations VS stored procedures	1	May 18, 2023
Procedure Invalid Identifier in SQL / PLSQL	1	Jul 26, 2022
Prepared Statement and Stored Procedure	3	Feb 25, 2008
Help with Paypal Live Transactions	1	May 19, 2023
transactions	0	Nov 8, 2007
Transactions Questions	3	Jul 4, 2005
Best Practice / pattern for coding for transactions	6	Nov 17, 2006

Ask a Question