Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "analyzing sqlserver2008 cross-database transaction testing". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. Create the tp_ Test1 table in mysql:

Create table tp_test1 (

Tid int primary key not null

Tgrade int unique key not null

)

two。 The code in the sqlserver2008 database is as follows:

Declare @ tgrade int

Set @ tgrade=3

Begin

Begin try

Begin transaction--- starts a transaction

Insert openquery (cs_guoquanwang_c,'select tgrade from tp_test1') select @ tgrade;-- inserts data into the myssql library

Insert into tp_test1 values (cast (getdate () as varchar (30)) + 'Test Cross-database transactions');-- insert data into the native server

Commit transaction;-- commit transaction

End try

Begin catch

Rollback transaction;-- rollback transaction

Print 'rollback the transaction!'

End catch

End

From this we can see that sqlserver currently does not support transactions across different schema databases.

This is the end of the content of "analyzing sqlserver2008 Cross-database transaction testing". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.