how to create identity column in #test table.
I tried something like this but it doesnt' work.
select *, identity_col= identity(3) into #test from orders

I don't think you can do what you want using SELECT INTO.

You'll have to do it the "hard" way and create the table using DDL (CREATE TABLE #temp ADD COLUMN identitycolumn ... , etc.) then populate the newly created table via INSERT #temp SELECT ... FROM orders etc.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

yes, you can not create an identity column in a select statement, you must do what Jeff has proposed.

"The one language all programmers understand is profanity."