怎么样创建自动增长列
我想在创建视图的时候在第一列创建一个自动增长列!方便查询
CREATE VIEW dbo.v_OA_StaffInPosition
AS
SELECT A.*, C.Position_ID, C.SuperPosition_ID, C.PositionName,
C.PositionDescription
FROM dbo.tb_Staff A LEFT OUTER JOIN
dbo.tb_PositionMember B ON A.Staff_ID = B.Staff_ID LEFT OUTER JOIN
dbo.tb_Position C ON B.Position_ID = C.Position_ID
WHERE (A.Dimission = 0)
[解决办法]
视图是依附于基础表的，你得从基础表上加
