I try to find out how a certain temporary table is created in SQL Server Management Studio because some datas in this table are incorect so I need to fix it, but I can't get to the procedures that creates this table. I recently started working on this database so I don't know how the procedures and tables are related between them...so any hints will be very helpful ! Thank you !
我试图找出如何在SQL Server Management Studio中创建某个临时表，因为此表中的某些数据是incorect所以我需要修复它，但我无法找到创建此表的过程。我最近开始研究这个数据库，所以我不知道它们之间的程序和表是如何相关的...所以任何提示都会非常有用！谢谢 ！
1 个解决方案
#1
0
As far as I know there is no way to graphically "see" a temporary table. If you know the name of the temporary table you can write a normal query to see the content, something like:
据我所知，没有办法以图形方式“看到”临时表。如果您知道临时表的名称，则可以编写正常查询以查看内容，例如：
select * from #mytemporarytable
#1
0
As far as I know there is no way to graphically "see" a temporary table. If you know the name of the temporary table you can write a normal query to see the content, something like:
据我所知，没有办法以图形方式“看到”临时表。如果您知道临时表的名称，则可以编写正常查询以查看内容，例如：
select * from #mytemporarytable