久久久久久久av_日韩在线中文_看一级毛片视频_日本精品二区_成人深夜福利视频_武道仙尊动漫在线观看

SQL Server:如何為整個(gè)存儲(chǔ)過(guò)程設(shè)置默認(rèn)隔離級(jí)別

SQL Server: how to set default isolation level for the entire stored procedure?(SQL Server:如何為整個(gè)存儲(chǔ)過(guò)程設(shè)置默認(rèn)隔離級(jí)別?)
本文介紹了SQL Server:如何為整個(gè)存儲(chǔ)過(guò)程設(shè)置默認(rèn)隔離級(jí)別?的處理方法,對(duì)大家解決問(wèn)題具有一定的參考價(jià)值,需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)吧!

問(wèn)題描述

如果在 BEGIN 之后我有 SET TRANSACTION ISOLATION LEVEL ... 語(yǔ)句,給定的事務(wù)級(jí)別是否對(duì)存儲(chǔ)過(guò)程的整個(gè)范圍有效,無(wú)論我是否是否使用 BEGIN TRANSACTION ?也就是說(shuō),如果我有簡(jiǎn)單的 SELECT 語(yǔ)句,根據(jù)定義它們是原子的/事務(wù)性的,它們的默認(rèn)事務(wù)級(jí)別是否會(huì)設(shè)置為給定的級(jí)別?

If right after BEGIN I have SET TRANSACTION ISOLATION LEVEL ... statement, will the given transaction level in force for the entire scope of the stored procedure regardless if I use BEGIN TRANSACTION or not? Namely if I have simple SELECT statements, which are atomic/transacted by definition, will the default transaction level for them set to the given one?

BEGIN
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
 -- will a transaction level for a atomic transaction created by SQL Server for this statement be READ COMMITTED 
SELECT * FROM T
END

推薦答案

首先,SQL Server 中的默認(rèn)隔離級(jí)別是 Read Committed,因此除非您更改了默認(rèn)隔離級(jí)別,否則該語(yǔ)句不會(huì)真正執(zhí)行任何操作.

First, the default isolation level in SQL Server is Read Committed, so that statement doesn't really do anything unless you've changed the default isolation level.

但是,一般來(lái)說(shuō),是的,SET Transaction Isolation Level 會(huì)改變整個(gè)過(guò)程的隔離級(jí)別(實(shí)際上是連接的持續(xù)時(shí)間)

But, in general, yes, SET Transaction Isolation Level will change the isolation level for the whole procedure (the duration of the connection, in fact)

請(qǐng)記住,所有 SQL 語(yǔ)句都是隱式事務(wù),這意味著,例如,如果更新失敗 99%,它將自動(dòng)回滾;不需要 BEGIN TRAN/COMMIT.

Keep in mind that all SQL statements are implicit transactions meaning that if, for example, an update fails 99% through, it will rollback automatically; no BEGIN TRAN/COMMIT is necessary.

要回答您的問(wèn)題,是的,您的 SELECT 語(yǔ)句將繼承您設(shè)置的隔離級(jí)別(如果未設(shè)置,則為默認(rèn)值),除非您使用諸如 WITH NOLOCK 之類的查詢提示覆蓋該行為這將使單個(gè)查詢的行為就像您執(zhí)行了 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

To answer your question, yes, your SELECT statements will inherit the isolation level you set (or the default if you do not set one) unless you override the behavior with a query hint like WITH NOLOCK which will make the individual query behave as though you did SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

這篇關(guān)于SQL Server:如何為整個(gè)存儲(chǔ)過(guò)程設(shè)置默認(rèn)隔離級(jí)別?的文章就介紹到這了,希望我們推薦的答案對(duì)大家有所幫助,也希望大家多多支持html5模板網(wǎng)!

【網(wǎng)站聲明】本站部分內(nèi)容來(lái)源于互聯(lián)網(wǎng),旨在幫助大家更快的解決問(wèn)題,如果有圖片或者內(nèi)容侵犯了您的權(quán)益,請(qǐng)聯(lián)系我們刪除處理,感謝您的支持!

相關(guān)文檔推薦

Converting Every Child Tags in to a Single Column with multiple Delimiters -SQL Server (3)(將每個(gè)子標(biāo)記轉(zhuǎn)換為具有多個(gè)分隔符的單列-SQL Server (3))
How can I create a view from more than one table?(如何從多個(gè)表創(chuàng)建視圖?)
Create calculated value based on calculated value inside previous row(根據(jù)前一行內(nèi)的計(jì)算值創(chuàng)建計(jì)算值)
How do I stack the first two columns of a table into a single column, but also pair third column with the first column only?(如何將表格的前兩列堆疊成一列,但也僅將第三列與第一列配對(duì)?) - IT屋-程序員軟件開(kāi)發(fā)技
Recursive t-sql query(遞歸 t-sql 查詢)
Convert Month Name to Date / Month Number (Combinations of Questions amp; Answers)(將月份名稱轉(zhuǎn)換為日期/月份編號(hào)(問(wèn)題和答案的組合))
主站蜘蛛池模板: 精品视频成人 | 欧美黄色性生活视频 | 国产一区二区三区久久久久久久久 | 国产成人精品在线 | 亚洲精品综合 | 国产高清视频在线观看播放 | 五月天天丁香婷婷在线中 | 久久久久资源 | 亚洲欧洲成人 | 午夜天堂精品久久久久 | 91精品久久久久久久久久 | 中国黄色毛片视频 | 国产在线1区 | 亚洲人成网亚洲欧洲无码 | 黄色国产大片 | 中文字幕高清一区 | 精品成人一区二区 | 免费黄色录像视频 | 欧洲一区二区在线 | 欧洲一区二区在线 | 国产福利视频导航 | 久久99精品久久久水蜜桃 | 亚洲精品久久久久久久久久久久久 | 精品国产一区二区三区在线观看 | 成人欧美一区二区三区黑人孕妇 | 国产一级影片 | 欧美日韩综合一区 | 亚洲一区国产精品 | 久久久久国产一区二区三区 | 91青青草视频 | 精品一区二区三区在线观看 | 日韩av成人在线观看 | 91精品一区 | 亚洲性视频 | 成人免费看黄网站在线观看 | 黄色一级电影免费观看 | 一级片aaa| 一级高清 | 国产一级在线 | 新av在线| 久草在线高清 |