What is limiation of #TEMP table?

 Posted by Rajni.Shekhar on 4/17/2012 | Category: Sql Server Interview questions | Views: 1688 | Points: 40

You can give table name upto 116 characters only including # sign.

Create table #<more than 116 characters table name>

ID int,
NAME varchar(50)

You will get the following error.

Error: "The object or column name starting with '#<long string here>' is too long. The maximum length is 116 characters."

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response