The temporary table creation command with Order and Label fields causes the table to be dropped when the DB connection is refreshed.
IF EXISTS(SELECT 1 FROM tempdb..sysobjects WHERE name LIKE '#TABLO_:SPID_%')
DROP TABLE #TABLOCREATE TABLE #TABLO(
[SIRA] [smallint] NULL,
[ETIKET] [nvarchar](50) NULL,
)
INSERT INTO #TABLO(SIRA,ETIKET) values('2','test');select * from #TABLO
Share your experience
Got a question, a different solution or a note to add?
Log in or join us to write a comment.
Log in ↗︎Sign up ↗︎