How to create a local temporary able?

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

Interview FAQs |

Exclusive Questions |

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

GooglePlus

StumbleUpon

Delicious

Reddit

Email

Bookmark It

< Previous : How can we create a global temporary table?

Next > : How to drop a constraint?

Comments or Responses

Login to post response

More Interview Questions by Rajni.Shekhar

Latest Interview Questions