sqlserver 建 视图 添加一列自增ID
CREATE VIEW [dbo].[BaseOrganization_v]
AS
SELECT ROW_NUMBER() OVER ( ORDER BY pob.PropertyId ASC ) AS id,
--------基表没有id列,取下一列rownum做自增id
pob.PropertyId, (CASE WHEN pd_1.PropertyValue IS N
原创
2013-09-10 17:00:28 ·
9014 阅读 ·
0 评论