I am upgrading SQL Server 7.0 to SQL Server 2005 and have three questions.
1. What are the differences between Collations SQL_Latin1_General_CP1_CI_AS and SQL_Latin1_General_CP437_CI_AS (tempdb on SQL 2005 Collate = SQL_Latin1_General_CP1_CI_AS) and (SQL 7.0 database Collate = SQL_Latin1_General_CP437_CI_AS)?
2. What are the differences between Sort order ID 52 and 54?
3. Can someone demonstrate sample of SQL Query that will show how Sort order ID 52 and 54 acting?