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