What is limiation of #TEMP table?

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

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