SQL Server Error and Transaction Handling

preview_player
Показать описание

  1. Ted on MSSQL
Рекомендации по теме
SQL Server Tutorial 0:04:08

SQL Server Tutorial : Transactions and Error Handling in SQL Server

SQL Server Error 0:09:54

SQL Server Error and Transaction Handling

How to make 0:08:51

How to make a transaction in SQL Server that rolls back when an error occurs

Solve! Transaction log 0:08:36

Solve! Transaction log is full SQL Server Error 9002 in Microsoft SQL Server

Error handling in 0:17:46

Error handling in sql server Part 56

Transactions in sql 0:11:18

Transactions in sql server Part 57

T-SQL tutorial: Error 0:09:55

T-SQL tutorial: Error Handling, Full SQL Server Transact-SQL Course, Introduction (Lesson 9)

SQL Server Programming 0:23:08

SQL Server Programming Part 14 - Transactions

How to Create 1:25:36

How to Create an Ethereum Gas Tracker Website

SQL Server SET 0:04:53

SQL Server SET XACT_ABORT ON

Ultimate Guide to 0:08:50

Ultimate Guide to Managing, and Supporting Microsoft SQL Server | (Transactional Replication Error)

Stored Procecure, Transaction 0:09:41

Stored Procecure, Transaction processing, Exception handling SQL Server

Transaction in SQL 0:05:14

Transaction in SQL | How SQL Transaction Works | SQL Transaction Tutorial | Intellipaat

How to view 0:00:21

How to view the SQL Server Error Log?

SQL 2008 Series: 0:14:48

SQL 2008 Series: Transaction/Error handling

SQL FRIDAY #49 1:16:32

SQL FRIDAY #49 - Erland Sommarskog on 'Error and Transaction Handling in SQL Server'

Understanding Your SQL 0:09:31

Understanding Your SQL Server Error Log

Troubleshoot Error in 0:14:58

Troubleshoot Error in Transactional Replication || Record deleted at Subscriber || SQL DBA

How to find 0:01:20

How to find the SQL Server ErrorLog

Step by Step 0:04:40

Step by Step - Setup Transactional Replication - SQL Server 2019

sql server concurrent 0:07:33

sql server concurrent transactions

11 - Querying 0:54:11

11 - Querying with Transact-SQL - Error Handling and Transactions

Error handling in 0:24:04

Error handling in sql server 2000 Part 55

MySQL: AUTOCOMMIT, COMMIT, 0:02:38

MySQL: AUTOCOMMIT, COMMIT, ROLLBACK

Комментарии
Автор

Cool video. At 3:05, if Xact_abort equals =-1, then it seems redundant to have a rollback transaction statement. I am somewhat new to how the engine works. If the rollback statement was not there, would SQLServer rollback the transaction anyway? When are rollbacks implicit?

PigsOnBook
welcome to shbcf.ru