Hash Tables problem

[pooja gundlur]

I have created a Hash table on the SQL Server in a centralised server from my system. I have entered 2 values into the table. When I try to see the values from another system; I'm unable to see the records and its showing me no data. What can be the reason for this problem?

[vishnukumar]

Scope for the #table is within the window.
Single # table scope is local and
double ## table scope is global

[nageshkota]

Hi Pooja,

We have 2 types of Hash tables, they are local and global
Local is used as #tablename, which is having the scope with in the SP's or Functions or in Programs, Out of this scope you can not able to find the table.
where as for global is used as ##tablename, which can be able to access out side of the SP's or functions or Programs.

Hope this will help you.

-With Cheers
Nagesh

[selvi1]

does hash table in sql server mean the temp table ?Plz carify.

[nageshkota]

Yes, Hash table means a temp table.

[amitpatel66]

Check here