Looking into temporary tables in SQL Server

I have been delivering a certified course in MS SQL Server 2012 recently and I was asked several questions about temporary tables, how to create them, how to manage them, when to use them and what are the limitations of them. In this post I will try to shed light on this particular issue with lots of hands-on demos. Temporary tables and table variables make use of the system tempdb database. I have installed SQL Server 2012 Enterprise edition in my machine but you can use the SQL Server 2012/2008 Express edition as well. I am connecting to my local instance through Windows Authentication and in a new query window I type (you can copy paste) First I am going to create a new temporary table and populate it. Execute the script below. USE tempdb GO IF OBJECT_ID('tempdb..#footballer') IS NOT NULL DROP TABLE #footballer; GO CREATE TABLE #footballer ( [FootballerID] INT IDENTITY NOT NULL PRIMARY KEY, [lastname] [varchar](15) NOT NULL, [firstname] [varchar](15) NOT NULL, [shirt_no] [tinyint] NOT NULL, [position_played] [varchar](30) NOT NULL, ); GO SET IDENTITY_INSERT [dbo].

✔ Read More...

I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blog, twitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.

This article is related to

Sql Server,Sql Server 2005,SQL Server 2008,SQL Server 2012,tempdb,temporary tables