sql server 2005 排序规则与大小写敏感　　 (sql server2005学习笔记1)

最新推荐文章于 2024-10-05 14:16:38 发布

weixin_30497527

最新推荐文章于 2024-10-05 14:16:38 发布

阅读量78

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/Rimbaud/archive/2006/04/26/385426.html

版权

If you installed Sql Server 2005 Full !

When Your Run Follow:
--------------------------------
use AdventureWorks
go
select * from sales.customer ----it's error!why?
select * from Sales.Customer----it's right!
---------------------------------

This issue is related to your database collation setting.

You can try run this to find out what your database collation is:

SELECT databasepropertyex(AdventureWorks','collation')

The collation of your database makes your query case sensitive.

If you want a quick change, you can change your database to another collation which is not case sensitive, for examle:

ALTER DATABASE AdventureWorks COLLATE SQL_Latin1_General_CP1_CI_AS

You can search Books online for more information on collation.

AND
There are some limitations on altering collation of a database, maybe there are some SCHEMABINGING views in the database. you can refers to SQL2005 Books Online, and locate:

'ALTER DATABASE (Transact-SQL)' topic ->'Remarks' section->'Changing the Database Collation'.

转载于:https://www.cnblogs.com/Rimbaud/archive/2006/04/26/385426.html