How to create a local temporary able?

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

Using # with table name, we can create a local temporary table.

CREATE TABLE #tempTable

(
id INT,
name VARCHAR(50)
)


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response