SQL Server: Difference between revisions

From Bitpost wiki
(Created page with "=== Case sensitivity === SQL Server is case-insensitive by default, to check specifically: select serverproperty('collation') SQL_Latin1_General_CP1_CI_AS < the CI in...")
(No difference)

Revision as of 13:23, 15 August 2018

Case sensitivity

SQL Server is case-insensitive by default, to check specifically:

select serverproperty('collation')
SQL_Latin1_General_CP1_CI_AS        < the CI indicates case-insensitive