Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
transaction in sql server
CREATE PROCEDURE [dbo].[Some_proc] AS BEGIN SET NOCOUNT ON; BEGIN TRAN BEGIN TRY select 5/0 COMMIT END TRY BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK; declare @err nvarchar(max) = ERROR_MESSAGE() RAISERROR (@err, 16, 1) END CATCH END go exec Some_proc
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Exam_3_Final
GKM_JOIN_1
Turn column into string
Teacher
ASDF
BC160401693
Table
tp3
how-to-assign-a-random-value-in-a-select-statement-in-sqlserver
Primeiro
Please log in to post a comment.