根据字母顺序将数据插入行中 [英] insert data in rows according to alphabet sort

问题描述

你好.

我正在使用SQlserver 2008r2，我的表称为:

城市(CityId，CityName)

我还在CityName字段中插入了一些引用，但其他引用已被删除
错了，我需要不在最后一行插入它们，但是我当然要
根据它们的字母将它们插入到先前的CityName行中

hello.

i am using SQlserver 2008r2 , i have table known as :

City(CityId , CityName)

i have also inserted some cites in CityName field but some others has been
mised , and i need to insert themm not in the final row ,but ofcourse i want
to insert them among the previous CityName rows according to their alphabet
sort , how can i do that?

推荐答案

那不是SQL的工作原理...

如何向我添加订单插入语句 [ ^ ]

That''s not how SQL works ...

how do i add order by to my insert statement[^]

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