在sql中有什么用@table [英] In sql what is the use of @table

问题描述

在sql中有什么用@table

解决方案

@ 符号用于变量和 table 是变量的名称。所以 @table 是对代码中某处定义的变量的引用。



@table实际上是什么取决于代码。它可以用于存储表的名称，表变量或完全不同的东西。没有看到相关代码，就不可能多说了。

请参考以下链接以便更好地理解。



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



http://www.sqlteam.com/article/temporary-tables [ ^ ]



快速概述：SQL Server 2005中的临时表 [ ^ ]



http://stackoverflow.com/questions/2219714/sql-server-tables-what-is-the-difference-between-and [ ^

In sql what is the use of @table

解决方案

@ symbol is used for variables and the table is the name of the variable. So @table is a reference to a variable defined somewhere in the code.

What the @table actually holds depends on the code. It could be used to store a name of a table, a table variable, or something totally different. Without seeing the relevant code it's impossible to say more.

Please refer below links for a better understanding.

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

http://www.sqlteam.com/article/temporary-tables[^]

Quick Overview: Temporary Tables in SQL Server 2005[^]

http://stackoverflow.com/questions/2219714/sql-server-tables-what-is-the-difference-between-and[^]

这篇关于在sql中有什么用@table的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！