使用SQL游标进行循环插入数据
--给新建页面添加权限控制
declare @RoleID varchar(50)
declare @Oprator varchar(50)
DECLARE AutoInsertRow CURSOR FOR
SELECT distinct RoleID, Operator FROM e
OPEN AutoInsertRow;
FETCH NEXT FROM AutoInsertRow into @RoleID,@Oprator;
WHILE @@FETCH_STATUS = 0
BEGIN
insert into tableT(RoleID,IID,Mode,Status,Operator) select top 3 @RoleID, IID, 2, '01',@Oprator from