sqlserver大小写:sql server 2005 排序规则和大小写敏感来源: 发布时间:星期六, 2009年2月7日 浏览:0次 评论:0
="t18">If you
 ed 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  ting.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  sensitive.If you want a quick change, you can change your database to another collation which is not 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'. 0
相关文章读者评论发表评论 |
|
 |
专注于互联网--专注于架构 |
最新标签 网站地图 文章索引 Rss订阅 |
