Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

SQL Server - Secret behind restriction of maximum length of 116 characters for temp table names

May 1 2012 12:00AM by Ramireddy   

I learned about this from Pinal Dave's blog(You can see the original article in references.)

In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 characters only.

SQL Server allows you to create temp tables with same names in different sessions. While creating temp tables, table names will be padded up with 12-byte magic string. This padding is to differentiate the table names that are created between different sessions. So, this padding takes up 12-bytes. Because of this, temp tables can have maximum of 116 characters only as their name.

Read More..   [54 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Ramireddy
2 · 40% · 12972
20
 
6
 
15
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server - Secret behind restriction of maximum length of 116 characters for temp table names" rated 5 out of 5 by 20 readers
SQL Server - Secret behind restriction of maximum length of 116 characters for temp table names , 5.0 out of 5 based on 20 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]