sql-server - SQL Server 中的哈希表？

Question

谁能解释一下 SQL Server 中的哈希表吗？

它与临时表相同吗？我在谷歌中搜索了哈希表的一些示例，但找不到任何

提前致谢

Answer 1

Hashtable is used to store temporary data.

1.The Hashtable object contains items in key/value pairs. The keys are used as indexes, and very quick searches can be made for values bysearching through their keys.

2.Temporary tables are a useful tool in SQL Server provided to allow for short term use of data. There are two types of temporary table inSQL Server, local and global.

当使用单#时定义为本地临时表，当使用双#时定义为全局临时表

请检查此链接。

http://www.nullskull.com/q/10298657/what-is-difference-between-temp-table-and-hash-table-in-sql--server.aspx (查看此链接中的更多其他链接以了解更多信息)

https://www.simple-talk.com/sql/t-sql-programming/temporary-tables-in-sql-server/