使用join select语句插入 [英] Insert with join select statement statement

问题描述

尝试创建一个insert语句存储过程。



我遇到的问题是安全ID没有增加插入相同的数字。



我需要它来检查pagesecurity表中的最后一个数字然后从那里开始增加。

Trying to create a insert statement stored procedure.

The problem I am having is the security id is not increasing insert the same numbers.

I need for it to check the last number in the pagesecurity table then increment from there.

SET ansi_nulls ON

Go
SET quoted_identifier ON

GO
create procedure pagesecuityinsert



As
Begin
Set Nocount on;
Declare @PageId bigInt
Declare @Rolename  varchar(256)
Declare @SecurityID bigInt
Declare @Rolename2  varchar(256)

insert into PageSecurity (PageID, RoleName, SecurityID) select @PageId, @Rolename, @SecurityID from PageDefinition
join PageSecurity on PageDefinition.PageID = PageSecurity.PageID 
where PageDefinition.PageType <> 'Top' and PageDefinition.PageType <> 'MENU' and PageSecurity.RoleName = @Rolename2


end

推荐答案

正如Richard C Bishop所说，设置 IDENTITY [ ^ ] for SecurityID 列。

As Richard C Bishop mentioned, set IDENTITY[^] for SecurityID column.

这篇关于使用join select语句插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！