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.