Click here to Skip to main content
14,458,710 members
Rate this:
Please Sign up or sign in to vote.
Hi Friends,
I have created temporary table in my project and it works, that is when I runs it. But I do not know much about temporary tables.
I would like to know if that is all that it takes to create temporary tables. I also would like to know if I can use stored procedure to execute the temporary table when I want to insert data into the tables from the front end application.

If there's more to it I will be willing to know.
Any assistance will be helpful.

This the actual table that I will be creating the temporary table for.
CREATE TABLE ITEMCODE_REGISTRATION 
( 
	ITEMCODE NVARCHAR(20)NOT NULL,
	ITEMNAME CHAR(50)NOT NULL,
	CATEGORY CHAR(25)NOT NULL
)

Please this is the temporary table I created
--Temporary table
CREATE TABLE #ITEMCODE_REGISTRATION 
( 
	ITEMCODE NVARCHAR(20)NOT NULL,
	ITEMNAME CHAR(50)NOT NULL,
	CATEGORY CHAR(25)NOT NULL
)


Thanks.
Posted
Updated 13-Aug-13 11:54am
v3
Comments
Maciej Los 13-Aug-13 8:30am
   
And a question is...

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Temporary tables usually are used to store data only for short time to perform some operation, like pivots, aggregates, etc.

For further information, please see:
Special Table Types[^]
Creating and Modifying Table Basics[^]
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100