SQL # 符号是什么意思，它是如何使用的? [英] What does the SQL # symbol mean and how is it used?

问题描述

谁能向我解释一下 # 符号在 MS SQL 代码中的含义.

Can someone please explain to me what the # symbol means in MS SQL Code.

我试过谷歌搜索，甚至在 StackOverflow 上搜索，但似乎找不到答案.

I've tried Googling it, and even searching on StackOverflow, but can't seem to find the answer.

我觉得自己像个白痴 - 度过了那些"日子.请帮忙.

I feel like an idiot - having one of "those" days. Please help.

推荐答案

它们通常为临时表​​添加前缀.

They normally prefix temporary tables.

来自文档....

前缀本地临时表名带有单个数字符号(#table_name)，和前缀全局临时表带有双数字符号的名字(##table_name).

Prefix local temporary table names with single number sign (#table_name), and prefix global temporary table names with a double number sign (##table_name).

这篇关于SQL # 符号是什么意思，它是如何使用的?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！