这句可能有错
select @count = count(*) from Temp where AssessID = @AssessID
if @count = 0
begin
insert into Clock
values(@ID,@AssessID,@ClockTime,@Time,@Late)
这句话是在这个存储过程里面
ALTER procedure [dbo].[proc_Addtab1]
(@ID int=0,
@AssessID varchar(20)=null,
@ClockTime varchar(20)=null,
@Time varchar(20)=null,
@Late varchar(20)=null)
as declare @count int
declare cur_test cursor LOCAL FORWARD_ONLY STATIC READ_ONLY for
select * from Temp open cur_test fetch cur_test into @ID,@AssessID,@ClockTime,@Time,@Late
while(@@fetch_status=0)
begin
select @count = count(*) from Temp where AssessID = @AssessID and [Time]=@Time
if @count = 0
begin
insert into Clock
values(@ID,@AssessID,@ClockTime,@Time,@Late)
end ---这句要提出来
fetch next from cur_test into @ID,@AssessID,@ClockTime,@Time,@Late
end --这两句也要提出来
close cur_test
deallocate cur_test
go我是想把有重复数据的Temp表中根据AssessID和Time这两个字段 过滤后插入到clock 中 但是插入不成功 是不是那句话有错啊
select @count = count(*) from Temp where AssessID = @AssessID
if @count = 0
begin
insert into Clock
values(@ID,@AssessID,@ClockTime,@Time,@Late)
这句话是在这个存储过程里面
ALTER procedure [dbo].[proc_Addtab1]
(@ID int=0,
@AssessID varchar(20)=null,
@ClockTime varchar(20)=null,
@Time varchar(20)=null,
@Late varchar(20)=null)
as declare @count int
declare cur_test cursor LOCAL FORWARD_ONLY STATIC READ_ONLY for
select * from Temp open cur_test fetch cur_test into @ID,@AssessID,@ClockTime,@Time,@Late
while(@@fetch_status=0)
begin
select @count = count(*) from Temp where AssessID = @AssessID and [Time]=@Time
if @count = 0
begin
insert into Clock
values(@ID,@AssessID,@ClockTime,@Time,@Late)
end ---这句要提出来
fetch next from cur_test into @ID,@AssessID,@ClockTime,@Time,@Late
end --这两句也要提出来
close cur_test
deallocate cur_test
go我是想把有重复数据的Temp表中根据AssessID和Time这两个字段 过滤后插入到clock 中 但是插入不成功 是不是那句话有错啊
没必要吧
这不是多此一举?
你这哪里有过滤?
values(@ID,@AssessID,@ClockTime,@Time,@Late)