declare @mname nvarchar(100)
declare my cursor
for
select FItemID
from hm_employees
OPEN my
FETCH NEXT FROM my into @mname
WHILE @@FETCH_STATUS = 0
BEGIN
insert into mytest
values ( @mname , getdate() )
fetch next from my into @mname
end
close my
deallocate my
hm_employees 这个是一个视图，视图中定义了只 SELECT top XX，发现当XX是10的时候运行正常，12的时候无效，30的时候无效，100的时候正常，300也正常，去掉top XXX后也正常，不知道原因出在哪