DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
SCRIPT & CODE EXAMPLE
CODE EXAMPLE FOR SQL
add id column to temp table insert
SELECT *, IDENTITY( int ) AS idcol INTO #newtable FROM oldtable
Source by stackoverflow.com #
PREVIOUS
NEXT
Tagged:
#add
#id
#column
#temp
#table
#insert
ADD COMMENT
Topic
COMMENT
Name
1+1 =
Submit