更改SQL Server数据库排序规则 [英] Changing SQL server database collation

问题描述

嗨专家，



您能否告诉我是否有办法更改已存在某些数据的现有SQL Server数据库的整理？



我用Google搜索并了解唯一的方法是删除数据库并重新创建并重新加载数据。



但我们的客户不想这样做。还有其他方法可以不干扰现有数据吗？



请帮助我。 。!!



提前致谢..



我的尝试：



删除数据库并创建新数据库。但我们不能采用这种方法。寻找其他方式..

Hi experts,

Can you please tell me if there is a way to change the collation of an existing SQL Server database in which we have some data already ?

I googled and got to know that the only way is to delete the database and recreate and re-load the data.

But our client don’t want to do that.is there any other way to do without disturbing the existing data ?

Please help me..!!

Thanks in advance..

What I have tried:

Delete database and create new. But we can't go with this method. looking for other way..

推荐答案

唯一可以保证数据顺序的方法是使用订单子句。如何在表中订购是无关紧要的。

The only way you can guarantee the order of data is to use the order by clause when you perform a query. How it is ordered in the table is inconsequential.

这篇关于更改SQL Server数据库排序规则的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！