数字未按升序插入表中 [英] numbers not inserting in ascending order into table

问题描述

int s =从roomdetails中选择isull(max([rid])，0)+1

(注意:如果我去10,11，最多可正确插入roomno 9，然后将其存储在roomno 1的下一行中)

创建表roomdetails(roomno nvarchar(250))

插入roomdetails(@roomno)值；
[我不应该将roomno更改为int]


Roomno
1
10-[错误地存储在这里]
2
3
4
5
6
7
8
9
-[应该来到这里]

int s=select isnull(max([rid]),0)+1 from roomdetails

(Note: Upto roomno 9 inserting correctly if i go 10,11 then its getting store in below row of roomno 1)

Create table roomdetails (roomno nvarchar(250))

insert into roomdetails(@roomno) values(s);
[ i am not suppose to change roomno into int]


Roomno
1
10 -- [wrongly stored here]
2
3
4
5
6
7
8
9
--[should come here]

推荐答案

您的意思是您从roomdetails中选择行的地方10在1后面，而orderby子句在roomno上吗?
您的房间没有糖柱吗?如果没有，那将会发生.对于排序的字符串，它是1后面的10，而不是2.

You mean where you select rows from roomdetails 10 comes after 1 and your orderby clause is on roomno?
Is your roomno an integar column? If not, then this will happen. For sorted string, it is 10 after 1 and not 2.

为什么不使用order by子句选择记录?

Why not you selecting the record using order by clause?

Select [rid] From roomdetails Order By [rid]

这篇关于数字未按升序插入表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！