数据库出现主键为空时的处理方法

最新推荐文章于 2023-01-11 10:06:18 发布

qiqingxueye

最新推荐文章于 2023-01-11 10:06:18 发布

阅读量3.2k

点赞数

本文链接：https://blog.csdn.net/qiqingxueye/article/details/46042167

版权

CREATE VIEW [Enterprise].[SelfSafeRankView]
AS SELECT ROW_NUMBER() OVER (PARTITION BY ssr.Id ORDER BY ssr.Id) AS Id, ssr.Id AS SelfSafeRankId,sr.Id AS SafeRankId,ssr.CompanyId,ssr.SelfSafeRankMinusScore,ssr.SelfSafeRankScore,sr.[Standard],sr.StandardScore,sr.ScoringWay,sr.According,sr.Comment,sr.Category
FROM [Enterprise].SelfSafeRank AS ssr
RIGHT JOIN [Enterprise].SafeRank AS sr
ON ssr.SafeRankId=sr.Id