Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Search in titles only
Search in SQL Server only
Search
Advanced Search
Forums
BYTES
Product Launch
Updates
Developer Toolkit
Member List
Calendar
Today's Posts
Home
Forum
Topic
SQL Server
Hash tables
Hash tables
Collapse
X
Collapse
Posts
Latest Activity
Photos
Page
of
1
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Filtered by:
Clear All
new posts
Previous
template
Next
gnanijs
New Member
Join Date:
Oct 2008
Posts:
2
#1
Hash tables
Oct 30 '08, 11:00 AM
What is the difference between single hash table (#table_name)
and double hash table (##table_name).
ck9663
Recognized Expert
Specialist
Join Date:
Jun 2007
Posts:
2878
#2
Oct 30 '08, 08:46 PM
They're temp tables.
Here's
a good read.
Happy Coding!
-- CK
Comment
Post
Cancel
gnanijs
New Member
Join Date:
Oct 2008
Posts:
2
#3
Oct 31 '08, 08:07 AM
That's great definition. Thank you
Comment
Post
Cancel
elracorey
New Member
Join Date:
Feb 2012
Posts:
1
#4
Feb 14 '12, 02:22 PM
Originally posted by
ck9663
They're temp tables.
Here's
a good read.
Happy Coding!
-- CK
How did such a lame reply get to the top of the Google rankings?
The double hash is a global temporary table, and the single is a local one. Shame I didn't find the answer here.
Comment
Post
Cancel
Previous
template
Next
Working...
OK
OK
Cancel
👍
👎
☕
Comment