StoreProcedure中的临时表的工作 [英] Working Of Temporary Table inside StoreProcedure

问题描述

我已经在存储过程内部创建了一个临时表.

问题就是这样.

我想知道
如果有1000位用户单击aspx页面上的SEARCH按钮，则会触发下划线存储过程.

可以吗?

请

I have created a temporary table inside store Procedure.

The Problem is as such.

I want to know that
If 1000 user click a SEARCH button on aspx page which Fires the underline store Procedure.

Will it work fine.

Please

推荐答案

是的，只要您的临时表不在公共场所，此方法仍然有效.我在说什么.

有3种创建表格的方式
1.创建表## tempTable ---这是公共表，可以访问不同的查询
2.创建表#tempTable ---只能在当前查询中访问
3.将@Table声明为Table ---仅可以在当前查询中访问.这2个的区别是速度.

yes this is still works as long as your temporary table is not in public. Here is what im talking about.

There are 3 ways of creating tables
1. Create Table ##tempTable --- This is Public and can be access in to different Query
2. Create Table #tempTable --- Can be access only in the current Query
3. Declare @Table as Table --- Can be access only in the current Query. The difference of this 2 are the speed.

这篇关于StoreProcedure中的临时表的工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！