Oracle转为MsSql，不知道怎么弄啊
create   table   scott.test
as  
(
select   distinct   empno,ename,hiredate
from   scott.emp
where   empno> 7000
);

------解决方案--------------------
try

Select distinct empno,ename,hiredate Into scott.test
From scott.emp
where empno> 7000
------解决方案--------------------
create table scott.test
(
empno int,
ename varchar(50),
hiredate datetime
)
go
insert into scott.test
select distinct empno,ename,hiredate
from scott.emp
where empno> 7000
------解决方案--------------------


select * into scott.test from
(
select distinct empno,ename,hiredate
from scott.emp
where empno> 7000
)t