declare @i int
declare @n int
declare @cn varchar(5)
set @i=1
set select @n=count(*) from dbo.BA_LoopInfoDetailswhile @i<@n
set @cn = cast(@i as nvarchar(5)) 加了这句之后卡主了
begin
select @cn as cn
set @i=@i+1
end不知道为什么,n = 100,数据量也不大,但这个执行后就一直不出结果“正在执行批查询...”好像是这里转换的地方有问题请大家帮忙看看原因
declare @n int
declare @cn varchar(5)
set @i=1
set select @n=count(*) from dbo.BA_LoopInfoDetailswhile @i<@n
set @cn = cast(@i as nvarchar(5)) 加了这句之后卡主了
begin
select @cn as cn
set @i=@i+1
end不知道为什么,n = 100,数据量也不大,但这个执行后就一直不出结果“正在执行批查询...”好像是这里转换的地方有问题请大家帮忙看看原因
set @cn = cast(@i as nvarchar(5)) 加了这句之后卡主了
--WHILE只会循环上面那一句,所以是死循环
begin
select @cn as cn
set @i=@i+1
end
declare @i int
declare @n int
declare @cn varchar(5)
set @i=1
set select @n=count(*) from dbo.BA_LoopInfoDetails while @i <@n
begin
set @cn = cast(@i as nvarchar(5)) 加了这句之后卡主了
select @cn as cn
set @i=@i+1
end
declare @n int
declare @cn varchar(5)
set @i=1
select @n=count(*) from dbo.BA_LoopInfoDetails while @i <@n
begin
set @cn = cast(@i as nvarchar(5)) --加了这句之后卡主了
select @cn as cn
set @i=@i+1
end
加了这句之后卡主了
begin
set @cn = cast(@i as nvarchar(5))
select @cn as cn
set @i=@i+1
end