// Yazılım

Creating a SQL Temporary Table

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

 

 

// FEEDBACK

Was this useful?

Your rating shows how helpful this note is to other readers.

Was this useful?

Click the stars to rate.

Average rating 0 / 5. Total votes: 0

No one has rated this post yet. Be the first!

Sorry this post was not helpful.

Your feedback is valuable to us.

How can we make this post more helpful?

// JOIN THE CONVERSATION

Share your experience

Got a question, a different solution or a note to add?

// KEEP READING

One more note.

All posts ↗︎