MS-SQL 가상테이블 만들기

CREATE TABLE #REQMEMO
( Cno INTEGER NOT NULL,
Sno INTEGER NOT NULL,
xName VARCHAR(8000) NOT NULL,
Ident INT IDENTITY(1,1) NOT NULL PRIMARY KEY )

INSERT #REQMEMO
( xName, Cno ,Sno)
SELECT
COUNSEL_CONTENTS,COUNSEL_NO ,SEQ_NO
FROM TABLE01 WHERE COUNSEL_GUBUN = 1
order by counsel_no, seq_no
;