é便å½äºç¹æ°æ®
Create Table KaList
(
KID int identity(1,1),--
CardNo varchar(64) ,--å¡å·
)
insert into kalist(cardno) values ('CK5015')
insert into kalist(cardno) values ('CK5016')
insert into kalist(cardno) values ('CK5018')
insert into kalist(cardno) values ('CK5019')
insert into kalist(cardno) values ('CK5020')
insert into kalist(cardno) values ('CK5022')
æ§è¡ï¼
declare @cardno varchar(64)
declare @str varchar(2)
declare @num int
declare @cnt int
set @num=5016
set @str='CK'
while @num<=5116
begin
set @cardno=@str+cast(@num as varchar)
select @cnt=count(*) from kalist where cardno=@cardno
if @cnt>0
begin
print @cardno
end
set @num=@num+1
end
æ§è¡ç»æï¼
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6a600c338744ebf89979ecf6d2f9d72a6159a7eb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)