31 lines
652 B
Transact-SQL
31 lines
652 B
Transact-SQL
BEGIN TRANSACTION
|
|
DECLARE @q NVARCHAR(MAX) ='
|
|
begin transaction
|
|
begin try
|
|
print ''go!'';
|
|
--waitfor delay ''00:01:15'';
|
|
raiserror(''test'',20,1);
|
|
end try
|
|
begin catch
|
|
print ''in catch''
|
|
if @@trancount > 1 begin
|
|
ROLLBACK TRANSACTION;
|
|
print ''rollback!''
|
|
end
|
|
print ''exit catch''
|
|
end catch
|
|
rollback transaction;
|
|
print ''done''
|
|
'
|
|
EXEC(@q) AT wam219a02
|
|
ROLLBACK TRANSACTION
|
|
|
|
SELECT *
|
|
FROM Arizona.INFORMATION_SCHEMA.TABLES t
|
|
WHERE t.TABLE_NAME LIKE '%request%'
|
|
|
|
SELECT TOP 100 *
|
|
FROM Arizona.wkl.OrderRequest
|
|
WHERE CreatedOn BETWEEN '20230307 13:31:30' AND '20230307 13:33:00'
|
|
ORDER BY OrderRequestId DESC
|