我要评论declare @a int,@str nvarchar(100),@i int,@j int,@m int, @n int,@q int
create table table_order(
id int,
num int,
)
set @str='1,3,2,5,4,6';
set @a=len(@str)
set @i=1
while @i<=(@a+1)/2
begin
insert table_order(id,num) values(@i,substring(@str,2*@i-1,1)) --将str里的数直接插入表中
set @i=@i+1
end
select * from table_order --查询表的初始数据
set @i=1
set @j=1
while @i<=(@a+1)/2
begin
set @m= (select num from table_order where id =@i)
set @j=@i+1
while @j<=(@a+1)/2
begin
set @n= (select num from table_order where id =@j )
if @m>=@n
begin
update table_order set num=@m where id=@j
update table_order set num=@n where id=@i
end
set @j=@j+1
end
set @i=@i+1
end
select * from table_order
运行结果：
本文地址：https://blog.csdn.net/qq_44108455/article/details/107637085
您可能感兴趣的文章:
如您对本文有疑问或者有任何想说的，请 点击进行留言回复，万千网友为您解惑！
网友评论