create or replace view project as
select ROWNUM AS ID,"P001_PROJID" AS CODE,
"P001_PROJNAME" AS NAME,"P001_EVAPROJ" AS REMARK
from PROJECTHRIS;ORACLE中创建的视图改成SQLSERVER要怎么改?
主要是那个ROWNUM的问题。
select ROWNUM AS ID,"P001_PROJID" AS CODE,
"P001_PROJNAME" AS NAME,"P001_EVAPROJ" AS REMARK
from PROJECTHRIS;ORACLE中创建的视图改成SQLSERVER要怎么改?
主要是那个ROWNUM的问题。
比如你的表是a,那么先
SELECT ID_NUM=IDENTITY(int, 1, 1),a.*
INTO temp_a
FROM a
这样就把原来表a的全部数据写到了temp_a并且加了一个列自动增加的ID_NUM
然后再
create view project
as select * from temp_a
这样就建了一个视图,但它的数据只是你的旧数据
如果你的表结构能变的话用这个方法先加个indetity的列,就可以了建一个真正的视图了
不知道还有没有别的方法,看楼下的
select *, [id]=(select count(1) from jobs b where b.job_id<a.job_id)+1 from jobs a