|
#2
mxbing19842015-04-17 17:23
|
程序代码：declare @hao varchar(50);
set @hao='01015000001';
declare @i int
set @i=1
while @i<5
begin
select * from PDM_DOCID where CSYMBOL in ('P'+@hao);
set @hao=convert(int,@hao)
set @hao=@hao+1
set @hao=convert(varchar,@hao)
set @i=@i+1
end
想做个查询循环，但是查询的字符串为PXXXX，想把XXXX加1，循环查询。循环不出结果，求告知哪里出了问题。 set @hao='01015000001';
declare @i int
set @i=1
while @i<5
begin
select * from PDM_DOCID where CSYMBOL in ('P'+@hao);
set @hao=convert(int,@hao)
set @hao=@hao+1
set @hao=convert(varchar,@hao)
set @i=@i+1
end