-
Junior Member
Hash Tables problem
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?
-
Junior Member
Re: Hash Tables problem
Scope for the #table is within the window.
Single # table scope is local and
double ## table scope is global
-
Contributing Member
Re: Hash Tables problem
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
-
Junior Member
Re: Hash Tables problem
does hash table in sql server mean the temp table ?Plz carify.
-
Contributing Member
Re: Hash Tables problem
Yes, Hash table means a temp table.
-
Expert Member
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules