Run Code
|
API
|
Code Wall
|
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
TARUN
Recursive cte (common table expression)
student table create
Combined Where and having
QUAN LY CHUYEN BAY
DGDFGDFG
Mc170404738
t1
1D Hotel
row number