問(wèn)題描述

考慮以下偽 T-SQL 代碼(由存儲(chǔ)過(guò)程執(zhí)行):

Consider the following psuedo T-SQL code (performed by a stored procedure):

CREATE TABLE #localTable ...

<do something with the temporary table here>

DROP TABLE #localTable;

DROP TABLE 語(yǔ)句是存儲(chǔ)過(guò)程執(zhí)行的最后一條語(yǔ)句——該語(yǔ)句有什么好處嗎?

The DROP TABLE statement is the last statement executed by the stored proceudre – is there any benefit to that statement?

請(qǐng)注意，我不是在詢(xún)問(wèn)在存儲(chǔ)過(guò)程的中間(即在不再需要表之后，但在存儲(chǔ)過(guò)程結(jié)束之前)刪除臨時(shí)表(本地或非本地)過(guò)程代碼)——由于減少了繼續(xù)執(zhí)行存儲(chǔ)過(guò)程所需的內(nèi)存，這似乎具有重要的好處.我想知道在存儲(chǔ)過(guò)程完成執(zhí)行時(shí)顯式刪除表與讓"SQL Server 這樣做是否有任何好處(或任何影響，實(shí)際上是積極的或消極的).

Note that I'm not asking about dropping temporary tables (local or not) in the middle of the stored procedure (i.e. after the tables are no longer needed, but before the end of the stored procedure code) – that could seemingly have important benefits due to decreasing the memory required to continue executing the stored procedure. I want to know whether there's any benefit (or any effect, really, positive or negative) to explicitly dropping the table versus 'letting' SQL Server do so when the stored procedure finishes executing.

推薦答案

這樣做不會(huì)有什么壞處，但是當(dāng)連接斷開(kāi)時(shí)表會(huì)被刪除.我個(gè)人認(rèn)為進(jìn)入是一個(gè)好習(xí)慣.它還可以讓開(kāi)發(fā)人員(可能需要為此工作)，您不會(huì)忘記這樣做.

Won't hurt to do so, but the table gets dropped when the connection is dropped. I personally think it's a good habit to get into. It also lets developers, who might have to work on this, that you didn't simply forget to do it.

這篇關(guān)于在存儲(chǔ)過(guò)程結(jié)束時(shí)顯式刪除本地臨時(shí)表有什么好處?的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！